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