Converting workbook references to R1C1 style to insert into VBA code

Perhaps

Please Login or Register  to view this content.

Originally Posted by RickCornelisse

I am trying to convert the following workbook reference/formula into an R1C1 reference to put into a macro.

Note: the active/selected cell in this case is C15.

=IF(D15=$D$4, $C$4, "")

The code I have is this:

Please Login or Register  to view this content.

Thanks in advance,
Rick

Why are you trying to convert it?
Although there are valid reasons to do so, I wanted to make sure that you are aware you can enter formulae in either format in most instances:

=IF(D15=$D$4, $C$4, "")
with activecell being C15

To enter it in R1C1 format:

Please Login or Register  to view this content.

To enter it in A1 format:

Please Login or Register  to view this content.

Hope that helps