Thread: Clearing the contents of a row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Clearing the contents of a row
Sheets(ToSheet).Range(ToTable).rows(1).ClearConten ts


John wrote:

Any idea why the following does not clear the contents of row 1 in ToTable?

Sheets(ToSheet).Range(ToTable)(1).ClearContents

I appreciate your help, -John

--

Dave Peterson
Reply With QuoteReply With Quote