View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hari Prasadh[_2_] Hari Prasadh[_2_] is offline
external usenet poster
 
Posts: 83
Default Relative/Absolute Formula writing in to a cell.

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