Copying Excel Fields

[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!

 

[johnwm]

This looks like Excel VBA rather than VB6. Try recording a macro and analysing the code produced, which covers many simple XL VBA stuff.

Failing that, try asking in forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller