Clearing a Worksheet

Hi,

What's the fastest way to clear a worksheet? I want to delete the contents of every cell without deleting any code from my module.

The reason I ask is, I'm reading from a text file into excel.

I want to run my code to read text into excel one time through. Then i want to delete all the text, make some alterations to my code, and run the code again. That way each time the worksheet is fresh and clear before i run the code.

Thanks for the help!

CrazyFileMaker,

Click the box above the "1", and to the left of "A".

Then click on "Edit", "Clear", "All".

Then click on cell A1.

Or, you could record a macro to do the same.

Or, try:

Please Login or Register  to view this content.

Have a great day,
Stan