How do I alter the below so that if I call the macro in a completely different sheet it will run fin on sheet Saturday?
Please Login or Register to view this content.
How do I alter the below so that if I call the macro in a completely different sheet it will run fin on sheet Saturday?
Please Login or Register to view this content.
If the call is made on the same workbook it will run fine.
otherwise,
Windows("yoursheet.xlsx").activate (the one that contains the Saturday tab)
... and then the rest of the code
Thanks for that Rcm but I want it so that the worksheet does not have to be active. So I'm looking for something like With Worksheets .sort. etc etc
So it should be something like...but this doesn't quite work atlhough I think it is close.......
Please Login or Register to view this content.
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks