Vba Cell Address Question

[MJSlattery]

I am attempting to direct a macro to copy data. It does not like my
attempt to define where the cell is. That is not a hard address.

How do you use a calculation from another cell as an address.

VBA compiler does not like ADDRESS(8,D5) or CELL(8,D5) or $D5.

What is the correct way to set an indexed cell address?

Thanks,

Michael

 

[JMay]

You mean like Range("D5").Address or Cells(5,4).address -- --- will get
you $d$5