| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute and Relative Cell References | Excel Discussion (Misc queries) | |||
| Relative (vs. Absolute) Cell References with macros | Excel Discussion (Misc queries) | |||
| Formula - relative or absolute ref, keeps changing | New Users to Excel | |||
| F4 key does not toggle relative/absolute cell references. | Excel Worksheet Functions | |||
| Explanation Relative/Absolute Cell Reference | Excel Worksheet Functions | |||
![Hari Prasadh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
