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

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)

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

If there is only a single cell reference in the formula you can use:

RowNumber = ActiveCell.DirectPrecedents.Row

--
John Green
Sydney
Australia

"sommer" wrote in message
...
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)