Thread
:
clearcontents problem
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
clearcontents problem
) misssing. I've done this too
--
Don Guillett
SalesAid Software
"Frank" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett