Where Sheet1 is the CodeName of the WorksheetVB:Sheet1.UsedRange.Clear
Hello again cityzens of OZGRID
Gotta question about destroying the contense of a worksheet. If for instance I got a macro which uses a different source everytime I run it, and this macro gives a result in a result worksheet. How can I possibly delete the contense of the result worksheet automatically before the execution starts?
What I mean is: without selecting all the cells and pressing delete or either using a for loop to go through all the worksheet cells. Is there any function which clears the contense of a worksheet? (without deleting the worksheet itself)
There are currently 1 users browsing this thread. (0 members and 1 guests)