Skip to content

Instantly share code, notes, and snippets.

@adam-acosta
Created October 16, 2012 14:53
Show Gist options
  • Save adam-acosta/3899768 to your computer and use it in GitHub Desktop.
Save adam-acosta/3899768 to your computer and use it in GitHub Desktop.
last row, final row [excel/vba]
finalrow = Cells(Rows.Count, 1).End(xlUp).Row
finalrow = Cells(Rows.Count, "C").End(xlUp).Row
finalrowORcolumn = Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row ' or LookIn:=xlFormulas
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment