Thread: How do I use absolute references in macros?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DaveO DaveO is offline
external usenet poster
  
Posts: 94
Default How do I use absolute references in macros?
Using A1 notation for cell B1 it would be...

Range("B1").Formula = "=$A$1"

HTH.

"Michael" wrote:

How do I setup absolute cell references in macros with either R1C1 format or
A1 format.
Reply With QuoteReply With Quote