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