Thread: Relative (vs. Absolute) Cell References with macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Excelenator Excelenator is offline
external usenet poster
  
Posts: 1
Default Relative (vs. Absolute) Cell References with macros

Sub Test()
Selection.Formula = "=3+" & ActiveCell.Offset(-1, 0).Address

End Sub


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=568020

Reply With QuoteReply With Quote