Thread: help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
View Single Post
  #3   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
sal2 wrote:
<<Example can I do this R1C1 + R2C3 = R3C4 or A1 + B2 = C3

You can't have operators on the left side of an equation.
Otherwise see my previous reply about using absolute/relative
references.
--
Regards,
Bill Renaud



Reply With QuoteReply With Quote