Clearing the contents of a row

John · Feb 7, 2009

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

Gary''s Student · Feb 7, 2009

The (1) is limiting the Clear to the first cell of the range.

Dave Peterson · Feb 7, 2009

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

Clearing the contents of a row

John

Gary''s Student

Dave Peterson