| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
RunTime Error
Getting an run-time error 1004 on this simple statement
Sheets("AllSheet").Select Range("A28:A29").Select Can't figure out why. |
|
#2
|
|||
|
|||
|
What does the error message say? Does your file have a sheet named
"AllSheet"? Look at the spelling carefully. Does the sheet name in the sheet tab have a space before or after the name? If you're not sure, rename the sheet the same name, being careful to not add a space before or after the name. HTH Otto "HeartSA" wrote in message ... Getting an run-time error 1004 on this simple statement Sheets("AllSheet").Select Range("A28:A29").Select Can't figure out why. |
|
#3
|
|||
|
|||
|
Should work unless AllSheet does not exist.
-- Gary''s Student "HeartSA" wrote: Getting an run-time error 1004 on this simple statement Sheets("AllSheet").Select Range("A28:A29").Select Can't figure out why. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime error | Excel Discussion (Misc queries) | |||
| Runtime error '1004' General ODBC error | New Users to Excel | |||
| runtime error '6' overflow | Setting up and Configuration of Excel | |||
| Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Linear Mode
