Finding the row number of first row in a selected range

  • Thread starter Thread starter Eamon Wall
  • Start date Start date
E

Eamon Wall

I'm attepting to find the row number of the first row in a user selected
range.
I'm looping throgh the rows to perform a comparison and can establish the
total number of row using

Dim Lrows as integer
Lrows = Selection.Rows.Count

How do I extract the row number of the first row, please.

Thanks in advance
 
msgbox selection.row



Eamon said:
I'm attepting to find the row number of the first row in a user selected
range.
I'm looping throgh the rows to perform a comparison and can establish the
total number of row using

Dim Lrows as integer
Lrows = Selection.Rows.Count

How do I extract the row number of the first row, please.

Thanks in advance
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

Copy Rows based on count of last row of another Column 1
Select low numbers from range + 6
lookup and return column number 2
VBA CreateNames (ignores last 5 rows?) 6
Search other sheets for numbers & color them 10
How to run a macro from the last populated row in a column 0
VBA selction of rows using a variable 5
Loop a code thru several worksheets 2

Back
Top