if "40 manual entry cells" isn't on the activesheet, then you can't select it.

so you could either select that sheet first--or just work directly on the range:

Range("40 manual entry cells").clearcontents



dcstech wrote:

I have a worksheet that has about 40 manual entry spots. I am trying to
delete the contents of the cells with the wokbook.open event. The code that I
am using is as follows:

Range("40 manual entry cells").select
selection.clearcontents

This has worked and works on other sheets accept this one.
Any suggestions?
Thanks for any help.

DCSTech

--

Dave Peterson