ExcelBanter - How do I use absolute references in macros?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I use absolute references in macros? (https://www.excelbanter.com/excel-programming/350772-how-do-i-use-absolute-references-macros.html)

Michael

How do I use absolute references in macros?

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

DaveO

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.

Michael

How do I use absolute references in macros?

Thank you.

"DaveO" wrote:

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.

All times are GMT +1. The time now is 03:39 AM.