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/