Thread: Clearing the contents of a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Clearing the contents of a row
The (1) is limiting the Clear to the first cell of the range.
--
Gary''s Student - gsnu200832


"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
Reply With QuoteReply With Quote