View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
haystack haystack is offline
external usenet poster
 
Posts: 2
Default following the active cell address without recalc

How can I get a cell in sheet1 to display the active cell address in sheet1
at all times without having to recalc when the active cell is changed? And
if that is possible, how then can I display in another cell in sheet1 the
address of a cell in sheet2 that corresponds to the active cell in sheet1
without having to recalc when the active cell in sheet1 is changed? Thanks