Hi.
I have opened a new excel workbook, and inserted an ActiveX command button. The command button is programmed in VB with the following code:
This produces the error "Run-time error '1004': Application-defined or object-defined error". I need help on how to select a range of cells, on a different worksheet, while using a variable as part of the cell adress. Thanks very much in advance!
Please Login or Register to view this content.
In a code module, default range references are to the active sheet. In a sheet module, they are to the sheet in which the code appears. So, ...
Having corrected the reference, though, there's no reason to select those cells to operate on them, and good reason not to.Please Login or Register to view this content.
Last edited by shg; 08-31-2009 at 12:31 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks