Assist with defining worksheet

[bradjedis]

Greetings,

I have a fairly large macro (one that I cannot share). However I think I know the direction I need to go, but not quite sure of the method.

we have defined the below,

Dim ExcelWorksheet As String

and use it like this:

ExcelWorksheet = "Tab1"

This works as expected, but I would like the macros to function on other tabs. Is there a way to have the ExcelWorksheet = "Tab1" function on the active worksheet?

Thaanks,
Brad

[HansV]

Use

ExcelWorksheet = ActiveSheet.Name

[bradjedis]

That did it! I knew it had "activeSheet", just not the rest...


Thanks,
Brad

[snb]

Refrain from using a variable and use activesheet anywhere you want to refer to the activeSheet.
Why using a variable for a variable Object reference?

PS. I never saw a macro that can't be shared.

[p45cal]

re 'PS. I never saw a macro that can't be shared.'

Well, you never would, would you? unless you wrote it yourself!

[snb]

Not even then.