Could be the OP was trying to do the select in one line without first
activating the sheet and kept getting an error message. Probably just wanted
to know how to get it to select A1 from another sheet.

"The Code Cage Team" wrote:


Rick, that wasn't aimed at you :)
I think the OP may be using something like:
Sheets("Holidays").Activecell.Value
Which of course serves no purpose or maybe the OP is forcing the select
hoping it may follow a hyperlink there....shots in the dark i know, and
yes it was an odd request.


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30124