Question Locked
Using VBA to clear an Excel Worksheet AND restore as original
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi I would like to use VBA to clear a worksheet and restore as to original state.
Sheet12.UsedRange.Clear
works but still the AutoFit I had done (programmatically) on the column earlier remains.
I would like to restore the cleared worksheet as though its a fresh one with absolutely no formatting (including AutoFit for the columns).
How do I do this?