| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to obtain the number of Column and Row from selected (active)cell?
Maybe this stupid, but it will add me in sure project.
For example, select mouse any cell, and I want, to : Cells("A1").Value = Row Cells("A2").Value = Col ' dim Row, Col as Integer but, Row = ???? (I don't know) Col = ???? (I don't know) Regards, Andrzej |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to obtain the number of Column and Row from selected (active) cell?
Try
rowId = Range(ActiveCell.Address).Row colId = Range(ActiveCell.Address).Column "And1" wrote in message ... Maybe this stupid, but it will add me in sure project. For example, select mouse any cell, and I want, to : Cells("A1").Value = Row Cells("A2").Value = Col ' dim Row, Col as Integer but, Row = ???? (I don't know) Col = ???? (I don't know) Regards, Andrzej |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to obtain the number of Column and Row from selected (active) cell?
Sub y()
Range("A1") = Selection.Row Range("A2") = Selection.Column End Sub On Mon, 05 Dec 2005 17:48:04 +0100, And1 wrote: Maybe this stupid, but it will add me in sure project. For example, select mouse any cell, and I want, to : Cells("A1").Value = Row Cells("A2").Value = Col ' dim Row, Col as Integer but, Row = ???? (I don't know) Col = ???? (I don't know) Regards, Andrzej |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to obtain the number of Column and Row from selected (active)cell?
Tx
Regards, Andrzej |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtain row number of active cell | Excel Worksheet Functions | |||
| How do I obtain cell information (column/row) from data marker? | Charts and Charting in Excel | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| How do I obtain total for auto filter value selected ? | Excel Discussion (Misc queries) | |||
| how can one obtain the current selected cell value | Excel Programming | |||
Linear Mode
