| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error when trying to work with different sheet
Yep,
I just got finished doing some code and went round and round on some similar issues until I got it right... F&F (fun and frustrating). Keep on Exceling! -- sb "TBA" wrote in message ... "steve" wrote in message ... TBA, Seems Excel wants the sheet specified... this works Private Sub cmd_RankBest_Click() Worksheets("Sheet1").Select Worksheets("Sheet1").Range("A1:Q36").Select 'selecting a range on sheet1 End Sub Thanks Steve! You were on the right track. After Googling this morning I got a tip where I used Worksheets("Sheet1").Select ActiveSheet.Range("A1:Q36").Select 'selecting a range on sheet1 Basically you were right about Excel wanting the sheet specified. Oh I love this stuff! ;) -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 | |||
Threaded Mode
