Thread: 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" <haertSA@yahoo.com> wrote in message
news:%23YFsc5D0FHA.1028@TK2MSFTNGP12.phx.gbl...
> 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.
>
>
>
>