Hi

I have been messing around for several hours to try and figure out how
to do this but can never get quite what I want. I need to be able to
run the macro and have it select a cell by using the row of the
current active cell and column B. say for instance cell D5 is active,
I would want the macro to select cell B5, if F15 were active then I
would want it to select B15.

Any help would be appreciated.

Thank