what's the return type of Row property?

[luolovepi]

Purpose: I want to know what is the next row number of my last row containing data. And what's the return type of ROW?

My code is like this:
Range("$F$65536").End(xlUp).Row+1

Is it correct?

 

[GTO]

.Row returns a Long.

Try:
<font face=Courier New><SPAN style="color:#00007F">Dim</SPAN> lLRow <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br>    <br>    <SPAN style="color:#00007F">With</SPAN> ThisWorkbook.Worksheets("Sheet1")<br>        lLRow = .Cells(.Rows.Count, "F").End(xlUp).Row + 1<br>    End <SPAN style="color:#00007F">With</SPAN></FONT>

 

[luolovepi]

Thanks a lot!
rgds,
S

.Row returns a Long.

Try:
Dim lLRow As Long

With ThisWorkbook.Worksheets("Sheet1")
lLRow = .Cells(.Rows.Count, "F").End(xlUp).Row + 1
End With

 

[Sektor]

Type in Immediate Window and press Enter:

? TypeName(Range("A1").Row)