Thread: absolute reference r1c1 code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SLP SLP is offline
external usenet poster
  
Posts: 58
Default absolute reference r1c1 code
How do I turn this so the first cell is an absolute reference? When I delete
the [] around the -1, I get an error message. Thanks.

ActiveCell.FormulaR1C1 = "=round(R[-1]c[0]*RC[7],2)"
Reply With QuoteReply With Quote