Can't really tell......but possibly you are not activating the "Input
sheet before selecting it

Try this:
Worksheets("Input").Activate
Worksheets("Input").Range("A5:B5").Select

Abhi

--
Abh
-----------------------------------------------------------------------
Abhi's Profile: http://www.excelforum.com/member.php...fo&userid=1585
View this thread: http://www.excelforum.com/showthread.php?threadid=24754