find row

  • Thread starter Thread starter CG Rosén
  • Start date Start date
C

CG Rosén

Good Day,

This is not working;

z = Application.WorksheetFunction.Row(ActiveCell)
MsgBox z.

How to find the row number of the ActiveCell by code?

Thanks for any help.

Brgds

CG Rosén
 
CG,

Try

Dim R As Long
R = ActiveCell.Row

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
msgbox ActiveCell.Row
Good Day,

This is not working;

z = Application.WorksheetFunction.Row(ActiveCell)
MsgBox z.

How to find the row number of the ActiveCell by code?
Click to expand...
 
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

Multi listbox change event - selected or deselected 6
label on top of a listbox 2
Limits in SQL query 3
change text in string 2
move item in multiselect listbox 1
Values from a ListBox 1
File dialog makes application visible 2
Find range by interior color 3

Back
Top