How do I convert a selected Cell address in a Range to Values?

[MichaelC]

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

 

[Toppers]

Hi,

Is this what you want ?

RowValue=ActiveCell.row
ColumnValue=ActiveCell.column

 

[MichaelC]

Thank you Toppers. I wil try that.

Hi,

Is this what you want ?

RowValue=ActiveCell.row
ColumnValue=ActiveCell.column

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