Absolute to Relative

[Guest]

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"

 

[Bob Phillips]

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)

 

[Dave Peterson]

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)

 

[Guest]

Thanks!
--
l-hawk

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)