Thanks Frank. Somehow earlier Change event hadn't worked and so I ha
opted for selectionchange event. But now it seems to work.

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27203