RunTime Error

[HeartSA]

Getting an run-time error 1004 on this simple statement

Sheets("AllSheet").Select
Range("A28:A29").Select

Can't figure out why.

 

[Otto Moehrbach]

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

 

[Gary''s Student]

Should work unless AllSheet does not exist.