Thread: help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
  
Posts: 417
Default help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
If you type in the formula in absolute form (i.e. "=$A$1:$Q$18), then
pull down the Tools menu, select Options, then click on the General tab,
then check the "R1C1 reference style, you will see "=R1C1:R18C17" in the
formula bar. Copy and paste from there.

If you leave the formula in relative form (i.e. "=A1:Q18"), you will get
"==RC:R[17]C[16]".
--
Regards,
Bill Renaud



Reply With QuoteReply With Quote