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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute to Relative
ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address(false,false) &
"-4" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "hawki" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute to Relative
ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address(0,0) & "-4"
Put your cursor on the word .Address (when you're in the VBE) and hit F1. You'll see a couple of options for rowabsolute and columnabsolute. (0,0) is the same as (false,false) which is the same as: (rowabsolute:=false,columnabsolute:=false) hawki wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute to Relative
Thanks!
-- l-hawk "Dave Peterson" wrote: ActiveCell.Formula = "=" & ActiveCell.Offset(0, -1).Address(0,0) & "-4" Put your cursor on the word .Address (when you're in the VBE) and hit F1. You'll see a couple of options for rowabsolute and columnabsolute. (0,0) is the same as (false,false) which is the same as: (rowabsolute:=false,columnabsolute:=false) hawki wrote: 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 -- Dave Peterson |
Reply |
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 |