Question

Locked

Using VBA to clear an Excel Worksheet AND restore as original

By chibuikei ·
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?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums