column value
 

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

column value
 

You might get it by using the Top/Left properties of Button and Cell,
but why not just code a number into the button_click event ?


---
Message posted from http://www.ExcelForum.com/