VBA find last row that is not #N/A

[wheatonrecurrence]

I have a column e.g. A1:A10.

With vba how do I get last non-NA value. In this case, it's 5, and store it in a variable?

Thanks.

 

[Fluff]

Assuming you have formulae in that column, try

Sub wheaton()
   Dim UsdRws As Long
   UsdRws = Range("A:A").SpecialCells(xlFormulas, xlErrors)(1).Row - 1
End Sub