Cell referencing in VBA

[Antonio00]

I have got some issues getting a cell address to be refrenced relative in a macro. When I am using the activecell.address command then the cell is absolute. When I am using the Row/Column comman with [ ] to signify relative reference then the reference is relative to the location of the formula and not the original cell. When I am selecting the D5 as part of the coding then I want D5 to be used not $D$5. What am I suppose to do here? Any ideas? Thanks.

[Mr. Boo Bear]

Can you tell us whether you are using the Macro Recorder, if so then click the Relative References button and see what does it do.

[Antonio00]

I just found a solution, all i needed to do was to add parameters to the ActiveCell.Address command to ActiveCell.Address(False, False, xlA1, False, False). It will make the cell reference relative. So, when I used the ActiveCell.Address.Column I was getting a number instead of the letter.