How do I find the last row number of a selection?
Selection.Row seems to give me the 1st row, but I can't figure out the syntax for the count of the rows or the last row, or even the range address. (actually all I need is the last row, just trying to find something to help me calculate it)
[VBA]
MsgBox Selection.Row + Selection.Rows.Count - 1
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
One way:
[VBA]Sub a()
Dim rng As Range
Set rng = ActiveSheet.UsedRange
MsgBox rng(rng.Count).Row
End Sub[/VBA]
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
I misunderstood the question. Please ignore.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
perfect - thanks.
I didnt think rows.count would work since I couldn't find it in my "watch" of the selection object.
how do I mark this thread solved?
Above your initial post is a drop down list headed by Thread Tools. Within that listing should be an option to Mark Thread Solved.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
