-
Help:How to identify the sheet number of the first sheet?
Hey All,
I have face this trouble when trying to copy sheet.
[VBA]
Sheets("SheetName").Move Before:=Sheets(1)[/VBA]
With the above code, I try to move one sheet to the first position.
But, unfuturnately, when I delete the first sheet, without close the file, and run this code again. And it return error.
With the same code, but after I save and close the file, and re-open it works again.
Please help
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