| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert a selected Cell address in a Range to Values?
I have a 10X12 Range of Input Values.
I want to select a cell within this range with my mouse. I want to use the cell address coordinates as values in a Macro. So: if ActiveCell Adress is (x,y) - [these can be column/row # or range coordinates] Then I want to say something like: RowValue = x ColumnValue = y So that I can use the RowValue and ColumnValue as offset values to create a standard macro for any cell selected within the range. I hope this makes sense - and I thank you in advance for all advice offered. Michael |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I convert a selected Cell address in a Range to Values?
Hi,
Is this what you want ? RowValue=ActiveCell.row ColumnValue=ActiveCell.column "MichaelC" wrote: I have a 10X12 Range of Input Values. I want to select a cell within this range with my mouse. I want to use the cell address coordinates as values in a Macro. So: if ActiveCell Adress is (x,y) - [these can be column/row # or range coordinates] Then I want to say something like: RowValue = x ColumnValue = y So that I can use the RowValue and ColumnValue as offset values to create a standard macro for any cell selected within the range. I hope this makes sense - and I thank you in advance for all advice offered. Michael |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I convert a selected Cell address in a Range to Values?
Thank you Toppers. I wil try that.
"Toppers" wrote: Hi, Is this what you want ? RowValue=ActiveCell.row ColumnValue=ActiveCell.column "MichaelC" wrote: I have a 10X12 Range of Input Values. I want to select a cell within this range with my mouse. I want to use the cell address coordinates as values in a Macro. So: if ActiveCell Adress is (x,y) - [these can be column/row # or range coordinates] Then I want to say something like: RowValue = x ColumnValue = y So that I can use the RowValue and ColumnValue as offset values to create a standard macro for any cell selected within the range. I hope this makes sense - and I thank you in advance for all advice offered. Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| How to sum Values in selected range? | Excel Programming | |||
| How do you get a Selected Range address into a variable? | Excel Programming | |||
| Inputbox to return address of cell selected by mouse | Excel Programming | |||
Linear Mode
