Menu

clearcontents problem

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
xlUnlockedCells ClearContents Possible ?	Corey	Excel Programming	3	January 4th 07 03:19 AM
Clearcontents	Caroline Vincent	Excel Programming	2	September 9th 04 11:03 AM
ClearContents - Except NamedRanges	Mike Fogleman	Excel Programming	8	September 2nd 04 01:19 AM
Clearcontents	K Dales	Excel Programming	0	February 27th 04 01:52 PM
Clearcontents	Dick Kusleika[_3_]	Excel Programming	0	February 17th 04 05:42 PM

All times are GMT +1. The time now is 06:08 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement