Remove $ From Cell Reference

[Draperies]

I have a macro that applies a previously saved address of some cell as a cell reference to another cell. Although this isn't my exact code, the effect is the same as the following:

ActiveCell.Offset(1, 0).Value = "=" & ActiveCell.Address

This however locks the cell reference using $'s. Is there anyway to do something similar and not include the $'s in the formula?

 

[Scott Huish]

Not sure why you're using .Value instead of .Formula but

ActiveCell.Offset(1, 0).Value = "=" & ActiveCell.Address(0,0)

 

[Draperies]

Wow, so simple!

Was using .Value instead of .Formula solely because I don't really know what I'm doing! Thanks for this!