I'd like to retrieve a columns value to add to a string in
a macro I'm creating.

At the top of each column I have a button, and I want to
get the current column value (e.g. A, B or C) into the
string I'm using to reference the cell locations I'm
attempting to update.

Is there anyway to get the current column value (text
format), based on the location of the button ?

Much appreciated for any help you can give me to get me in
the right direction.

Cheers

mark