Skip to content

Instantly share code, notes, and snippets.

@vndmtrx

vndmtrx/gist:2963269

Created June 21, 2012 01:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vndmtrx/2963269 to your computer and use it in GitHub Desktop.
Save vndmtrx/2963269 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.vb
Function busca_ultimo_registro(ByVal plan as String) as Object
Dim rows as Object
Dim i as Integer
rows = ThisComponent.getSheets().getByName(plan).getRows()
i = 0
Do
i = i + 1
Loop while rows.getByIndex(i).getCellByPosition(0,0).String <> ""
i = i - 1
busca_ultimo_registro() = rows.getByIndex(i)
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment