Macro to effect cell based on column

I wasnt sure how to name this problem, but here goes.

Please Login or Register  to view this content.

The code above takes the value of a cell in on my worksheet and adds a further value ontop of it.

The problem - I need to be able to use this formula on the rows numbered 5 by selecting only the column needed.

Example;Column B is selected. When I activate the macro it will effect B5.
Column CD is selected. When I activate it will effect CD5.

And so on.

Thanks in Advance!

Try this

Please Login or Register  to view this content.

Please mark your thread solved & rate the answer using the scales icon