extract cell reference in one formula and add it to another formul

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to extract the row number of a cell reference in one
formula and add it to a formula in another cell? For example, A10 is the
active cell and it contains the formula ='DataSheet'!AB246. I would like to
extract the row number (246) from the formula in A1 and insert it into
another cell (D10) that contains the formula ='DataSheet'!BC(row number
246)*pi()/180+'DataSheet'!CA(row number 246)*.5

Thanks for your help! (Excel 2000)
 
If there is only a single cell reference in the formula you can use:

RowNumber = ActiveCell.DirectPrecedents.Row
 
Back
Top