I'd bet it's because the cells() stuff isn't qualified:

with Worksheet("Sheet2")
.Range(.cells(rowcounter, columncounter), _
.cells(rowcounter+2,columncounter +2)).clearcontents
end with

ps. it's better to copy|paste from the VBE than to retype the code and
introduce other typos. (Like missing a closing paren.)



Frank wrote:

I am using a commandbutton_click sub on a specific worksheet to automate some
reset features on a timesheet I've built. I want to be able to clear and
reset values on other worksheets in the same workbook at the same time.
Inside the commandbutton1_click sub on "Sheet1" I use the code

Worksheet("Sheet2").Range(cells(rowcounter,
columncounter),cells(rowcounter+2,columncounter +2).clearcontents

where rowcounter and columncounter are locally dimmed integers with verified
values (I can see them in the debug)

However, I get a run time 1004 error when this line executes -- if I change
the range designation above to "A1:C3" format, I don't get the error. Is it
a problem that rowcounter and columncounter are locally defined?

Any help or advice would be appreciated.

Thanks.

--

Dave Peterson