Get number of row in Range

[always_confused]

Hello,

I am trying to write a Sub in which I need the number of rows in a Range which is input as a parameter of the Sub. I can't find the syntax to get the number of rows in the range. For other functions where the range is already known (in this case Range("A:A")) when writing, I've been using:

lastrow = Sheets("sheetname").Range("A" & Rows.count).End(xlUp).Row

But I'm not sure how to do the same thing in the case where I have

Dim column As Range
Set column = Range(M:M)

How can I get the number of used rows of Range(column)?

 

[maabadi]

If you have same row at column M with Column A then

Dim column As Range, Lastrow as Long
lastrow = Sheets("sheetname").Range("A" & Rows.count).End(xlUp).Row
Set column = Sheets("sheetname").Range("M2:M" & lastrow)

 

[always_confused]

If you have same row at column M with Column A then

Dim column As Range, Lastrow as Long
lastrow = Sheets("sheetname").Range("A" & Rows.count).End(xlUp).Row
Set column = Sheets("sheetname").Range("M2:M" & lastrow)

I don't have the same number of rows. I would like to get the number of rows in Range(column). Column is whatever I input into the Sub, it's length has nothing to do with other rows

 

[maabadi]

Try this:

Dim column As Range
Set column = Range(Range("M2"), Range("M" & Rows.Count).End(xlUp))

 

[always_confused]

Try this:

Dim column As Range
Set column = Range(Range("M2"), Range("M" & Rows.Count).End(xlUp))

I appreciate this but I don't think you're understanding my problem. I have a Sub like this:

Sub (column As Range)

For i = 1 To last_row_of_column
' do some stuff
Next i

End Sub

How do I get last_row_of_column ?

 

[always_confused]

Just changed column from Range to String = to the column letter instead of the whole column and it's fine now

 

[maabadi]

Glad you can sort it.