Re: Applying a macro to all worksheets
- From: "PMC1" <paulc05@xxxxxxxxx>
- Date: 15 Jan 2007 08:20:59 -0800
Use something like With Worksheets(Activesheet)
this will work with any work***.
There is no worksheets(All) as all the worksheets is really the
workbook collection
DannyS wrote:
I have a macro that contains the line:
With Worksheets("UK")
Can I get it to apply to all my worksheets?
Ie
With Worksheets(All)
Thanks!
.
- Prev by Date: Re: Autosort, but keep Row 1 seperate
- Next by Date: Re: how do i find unsaved work that i accidently deleted
- Previous by thread: Re: Is it possible to have a cell just quote the work*** name?
- Next by thread: Re: Applying a macro to all worksheets
- Index(es):
