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

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)
 
J

John Green

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

RowNumber = ActiveCell.DirectPrecedents.Row
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create labels on one sheet from active row on another sheet 4
Formula Help Needed (Sum and If Then) 1
Another Conditional Formating. NEED ANSWER TO FINISH PROJECT! 1
Replace cell formula with revised text as noted within a cell valu 3
Referencing cell range in another workbook with a formula 5
Insert Row also adds formulas and moves cursor 2
setting one worksheet cell range reference to another worksheet 1
Use cell contents to make formula reference 4

Top