Skip to content

Instantly share code, notes, and snippets.

@gtaing1

gtaing1/LastRow

Created April 11, 2017 22:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gtaing1/0cdb0fe2c53acba2a567e0621e6f0115 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gtaing1/0cdb0fe2c53acba2a567e0621e6f0115 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
LastRow
Dim lastRow As Long
lastRow = Range("C" & Rows.Count).End(xlUp).Row
Range("A7").AutoFill Destination:=Range("A7:A" & lastRow), Type:=xlFillCopy
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment