Macros and worksheets

[Guest]

I have a formula in a macro to work with worksheets that are named
differently. The formula requires that the name of the worksheet be placed
(i.e. "Wheaton") in the code.

Set ws = wb.Worksheets("Wheaton")

If I want this macro to work with the active worksheet how would I designate
it as the active worksheet.

Set ws = wb.ActiveworkSheet ?

Thanks for your help,
cinvic

 

[Dave Peterson]

set ws = wb.activesheet

I have a formula in a macro to work with worksheets that are named
differently. The formula requires that the name of the worksheet be placed
(i.e. "Wheaton") in the code.

Set ws = wb.Worksheets("Wheaton")

If I want this macro to work with the active worksheet how would I designate
it as the active worksheet.

Set ws = wb.ActiveworkSheet ?

Thanks for your help,
cinvic

 

[Guest]

Hey Mr. Peterson! Hope you're doing ok. Thanks again for you help.