Assign Worksheet Name in Macro

[joeharri]

I would like to assign a specific Worksheet name in a Macro.

Example:

Sheets("AP Drivers").Select

"AP Drivers" is what I want to change.
How do you assign this worksheet name at the beginning of the macro and have it pass everytime the Sheets*.Select command is used?

Thanks.

 

[Richard Schollar]

You can access the name property by for example:

Dim wsName as String

wsName = Sheets("AP Drivers").Name

which will assign the name "AP Drivers" to variable wsName.

Does this help?

Richard