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

I'm assuming that wksDump is the name of a sheet...

--
Ak


"MJKelly" wrote:


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