excel

  • Thread starter Thread starter hari
  • Start date Start date
H

hari

In excel , through visual basic program how do i know row number / column
number of active cell
 
Sub demo()

MsgBox "Row " & ActiveCell.Row
MsgBox "Column " & ActiveCell.Column

End Sub
 
There is nothing mysterious or magical about the ActiveCell... it is a range
just like Range("B1") or Cells(1,2) are... and it has the same properties as
do all range objects which include Row and Column...

MsgBox "(Row, Col) = (" & ActiveCell.Row & ", " & ActiveCell.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

Red cell for negative numbers in Excel 1
Count occurances in a range. 5
Can someone help me? 14
Moving from Excel to Visual Studio 3
Excel Active Cell 2
Excel 2007: Return rownumber when text data on 3 columns match exa 1
set cursor position after cell is populated?? 7
find and scroll to cell string value in Excel 2

Back
Top