set ws = wb.activesheet



cinvic wrote:

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