RunTime Error
Getting an run-time error 1004 on this simple statement
Sheets("AllSheet").Select Range("A28:A29").Select Can't figure out why. |
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. |
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. |
All times are GMT +1. The time now is 09:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com