You can reference a worksheet by number instead of name. E.g,

Worksheet(1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


wrote in message
ups.com...
Rody-

Thanks for the help.....but I am still getting the error. The
problem
lies with how I am naming the sheet. The name of "Sheet1" is
"Jun".
If I change the code to select "Jun" instead of "Sheet1" it
runs fine.
How can I get it reference the first sheet in the file....not a
specifically named sheet?

Thanks for the help!
-Chris