Using the ADDRESS function in code

[j_Southern]

I have a worksheet cell which contains a cell address obtained from a formula = Address(3,B5+365) this shows in the cell as $BDS$3
I need to use that address in code that I am using to fix a new position for a control button using something like

Please Login or Register  to view this content.

This code does not work
But was derived from

Please Login or Register  to view this content.

Which does
What I am trying to do is to use the address formula in the cell to achieve the second bit of code, the address varies of course.
Can some one point me the right way
John

[BMV]

Please Login or Register  to view this content.

[mjr veverka]

Please Login or Register  to view this content.

[j_Southern]

Thank you both for your help. You solved my problem and allowed me to move forward at last.
John