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.