Macros and worksheets

[cinvic]

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



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

[cinvic]

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

"Dave Peterson" wrote:

> 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
>