Cell referencing in VBA

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.

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.

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.