Copying fields in Excel

[PaidtheUmpire]

Hey guys,

I haven't used VB in a while so I'm going ask for some help a roo.

When you click the button, it see if the field selected has the value "Here" and if so it will go down a copy of cells and copy then to a lower location.

For example:
Cell Selected: B93 = "HERE"
Click button. As B93 is equal to "HERE" then cells C97 to G98 are copied to C101 to G102.

any ideas on how to do this semi-dynamically, as i want to be able to the copy from mulitple locations.

Thanks.

Delphi, Delphi, Delphi. Oi! Oi! Oi!

Delphi, Delphi, Delphi. Oi! Oi! Oi!

 

[PHV]

As a starting point play with the macrorecorder when you do what you want manually and then amend the generated code for the semi-dynamic stuff.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886