Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error when trying to work with different sheet
Excel 97
Windows 2k Pro I have a command button on sheet2 that needs to do some "stuff" on sheet1 and then copy said "stuff" back onto sheet2. This is a stripped down example of code for my command button on sheet2: Private Sub cmd_RankBest_Click() Worksheets("Sheet1").Select Range("A1:Q36").Select 'selecting a range on sheet1 End Sub But, I'm getting a run-time error '1004': Select method of Range class failed Is my code flawed? Any insights greatly appreciated. -gk- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
chart error message / work sheet not open ? | Charts and Charting in Excel | |||
Creating a Work place time sheet. | Excel Worksheet Functions | |||
How do I retrive my time sheet from AmeriCorps Work In Progress? | Setting up and Configuration of Excel | |||
How do I change . to : when input in a time sheet by error | New Users to Excel |