Thread: extract cell reference in one formula and add it to another formul
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sommer sommer is offline
external usenet poster
  
Posts: 3
Default 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)

Reply With QuoteReply With Quote