cells is the whole sheet

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MJKelly" wrote in message
...

Hi,

Can you tell me what is wrong with this code?


wksDump.Range(Cells(2, 1), Cells(1000, 256)).ClearContents

If I put in wksdump.cells.clearcontents it clears the whole sheet. I
want to keep the data in row 1.

hope you can help.

Thanks,
Matt