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