for your existing code, Selection is misspelled

you could just do

Range("D13:H13").Clearcontents

--
Regards,
Tom Ogilvy


"RPIJG " wrote in message
...
and for deleting cell contents, I was using this


Code:
--------------------
Range("D13:H13").Select
Selction.ClearContents
--------------------


that I captured using the macro recorder, but I get an error saying
object required or something of the like.


---
Message posted from http://www.ExcelForum.com/