How to obtain the number of Column and Row from selected (active)cell?

A

And1

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
 
B

Brian

Try

rowId = Range(ActiveCell.Address).Row
colId = Range(ActiveCell.Address).Column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Column number of last column that returns value ignore formulas 8
Delete rows takes forever 4
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
function - find first number in row > 0, return cell column number 3
Deleting Duplicate Rows In a Selection with a True Statement 2
find function Help 1
Trying to determine what cells within a Row have a 0 (zero) value 5

Top