Thread: How do I clear all cells from all rows except the first row in Sheet1?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default How do I clear all cells from all rows except the first row in Sheet1?
As long as the used range doesn't include the last row of the worksheet:

Worksheets("Sheet1").UsedRange.Offset(1).ClearCont ents

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Michael" wrote in message
oups.com...
How do I clear all cells from all rows except the first row in Sheet1?



Reply With QuoteReply With Quote