Announcement

Collapse
No announcement yet.

Clear All Worksheet Cells

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Clear All Worksheet Cells

    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)

    Thx guys

  • #2
    Re: Clear All Worksheet Cells

    Code:
    Sheet1.UsedRange.Clear
    Where Sheet1 is the CodeName of the Worksheet

    Comment


    • #3
      Re: Clear All Worksheet Cells

      Thank you very much Dave, you allways submit useful answers

      Comment

      Working...
      X