View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Cannon Jack Cannon is offline
external usenet poster
 
Posts: 2
Default Active Cell in Non-Active Worksheet

How does one get the row number of an active cell in a non-active worksheet?

For example if I am in Sheet2 and I wish to obtain the row number of the
active cell in Sheet 1 then what instruction will get it?

I am looking for something like:
=CELL("Row", Sheet1!ActiveCell)

Jack Cannon