Change to variable name

[Mohsin]

Hi there

Need your help please on my recorded macro;

ActiveCell.FormulaR1C1 = "GADNN01",

The "GADNN01" is different from every data, so how can i change to variable so as when i open this macro, the macro will detect whatever name as that line?

appreciate for your help

[Leith Ross]

Hello Moshin,

Add a variable above the active cell assigment line...

varData = "My data"
ActiveCell.FormulaR1C1 = varData

Sincerely,
Leith Ross

[Mohsin]

Hi Leith Ross

Thank you for your responces,
I just try your's suggestion, but the macro put the "my data" to replace the "GADNN01". What i need is to replace whatever "name" as in that line. The macro like this;

Please Login or Register  to view this content.

the macro will copy a data from range C7 (can be any name) and put in A2, so the "GADNN01" is changing from every data, as in C7

Appreciate for your help, thank you

[VBA Noob]

Hi,

Try

Please Login or Register  to view this content.

if you don't need the message then

Please Login or Register  to view this content.

VBA Noob

[Mohsin]

Hi

It's works, thanks VBA Noob and leith ross, for your help.

How can i use the function, = left("Mydata",length) as vba code?

thank you