| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute to Relative
The macro below returns a forumula that has an address that is absolute. How
would I force the macro to return an address that is relative (without the dollar signs)? ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address & "-4" -- l-hawk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative and absolute hyperlinks | New Users to Excel | |||
| name range from absolute to relative | Excel Worksheet Functions | |||
| Mix of relative and absolute? | Excel Programming | |||
| changing relative to absolute | Excel Discussion (Misc queries) | |||
| Chg Absolute to Relative | Excel Programming | |||
Threaded Mode
