-

Originally Posted by
john3j
Here is my code:
Remove:
shtName = ActiveSheet.Name
Change the remaining instance of
ActiveSheet.Name
to:
ActiveWorkbook.Worksheets(I).Name
OK, a little tidying up required like removing the leading semicolon which I'll leave to you.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules