Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) |