RunTime Error

  • Thread starter Thread starter HeartSA
  • Start date Start date
H

HeartSA

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
 
Back
Top