Hi,
In the below example z= 2.
If I put,
ActiveCell.Formula = "= " & Cells(z, "d").Address
Then in Cell H8, I get the formula as -- = $D$2 --
How do I modify my formula such that I get the value as -- = D2 --
Actually I dont want hard-coded/fixed referencing.
Thanks a lot,
Hari
India
Bookmarks