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

  • Thread starter Thread starter And1
  • Start date Start date
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
 
Try

rowId = Range(ActiveCell.Address).Row
colId = Range(ActiveCell.Address).Column
 
Sub y()
Range("A1") = Selection.Row
Range("A2") = Selection.Column
End Sub
 
You must log in or register to reply here.

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
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
using the cells property for use with Application.WorksheetFunction.Sum 2
Trying to determine what cells within a Row have a 0 (zero) value 5
Copying data from Sheet1 which is on multiple rows for each customerto Sheet2 on single row. 2
Help! Can’t debug macro used to delete duplicate rows 2

Back
Top