Automatic Change in Code

Is there any way, in which i can make my code dynamic?? For example, in a code written in VBA, there is a reference to particular sheet, say "ABC". If i change the name from "ABC" to "ABCD" from excel, the underlying code should change automatically from "ABC" to "ABCD".

I want to make my code dynamic..

I hope u get my problem... can any1 help me on this??

Say the sheet tab is always say sheet 3 then use the number

e.g

Please Login or Register  to view this content.

HTH

VBA Noob

What sheet number is your sheet ??


VBA Noob

c the code

Please Login or Register  to view this content.

#

This code is written in "ThisWorkbook"

There are another 30 sheets "060107" series... like "060207", "060307" etc.

Now if i change the name of the sheet "PLA" from Excel then the macro does not run. same as with other sheet.

Is there any way in which i can make things dynamic.. so that even some user changes the name from excel itself, the code should adjust automatically and macro should run as before.

Create a named range consisiting of one cell on PLA. Lets call it "Base"
Modify your code, replacing

Please Login or Register  to view this content.

, with

Please Login or Register  to view this content.

If the user changes the name of PLA, the name will automaticaly adjust and your code won't get lost.

Please read forum rules below and wrap the code

VBA Noob