I have 2 worksheets in a workbook, and I need to be able to select
cell or row from each worksheet and be able to find out which ro
number each of them are in.
I know that to get one you use ActiveCell.Row, but is there any way t
do this specifying the sheet it is comming from, so I can do it for
different sheets in the same macro?
Thanks
Catherin

--
Catherine
-----------------------------------------------------------------------
CatherineN's Profile: http://www.excelforum.com/member.php...fo&userid=3546
View this thread: http://www.excelforum.com/showthread.php?threadid=55247