Hi Norman

Thanks for your advice but the original purpose of my post is to se
whether is it possible to select a specified range in a specified shee
without actually activating the worksheet...

I have succeeded in doing so partially... I managed to get the code t
select the range without activating the sheet but for some reason, i
will only select one cell and not the whole range... which reall
puzzles me...

Anyway i really appreciate your help...

Cheer

--
hc
-----------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351
View this thread: http://www.excelforum.com/showthread.php?threadid=26445