VBA Immediate window

[jakobt]

Have written a macro to identify the last used row in a column:

sub_find_last_row()

dim last_row as integer
lastrow = range("B2"), range("B" & rows.count).end(xlup).row
end sub

I want to test if a row number was assigned to the variable so I open immediate window:

? Last_row

But no number is shown/calculated.

 

[RoryA]

Last_row is declared within that routine. After you have run it, the variable goes out of scope and loses its value. Really, I suspect that should be a function.

 

[alansidman]

change this line of code

[COLOR=#333333]lastrow = range("B2"), range("B" & rows.count).end(xlup).row

to

[/COLOR]

[COLOR=#333333]last_row = range("B2"), range("B" & rows.count).end(xlup).row[/COLOR]

You have not been consistent in your variable name.

 

[Fluff]

There are a number of problems with the code you supplied, try

Sub find_last_row()

Dim last_row As Integer
last_row = Range("B" & Rows.Count).End(xlUp).Row
Debug.Print last_row
End Sub