Skip to content

Instantly share code, notes, and snippets.

@agbishara

agbishara/VBA - Copy and Paste Visible Cells in Range

Created April 15, 2014 16:03
Show Gist options
  • Save agbishara/10744042 to your computer and use it in GitHub Desktop.
Save agbishara/10744042 to your computer and use it in GitHub Desktop.
Download ZIP
This is good if you need to filter on a worksheet and do a special copy
Raw
VBA - Copy and Paste Visible Cells in Range
Mainbook.Sheets(4).Range("E2:k5000").SpecialCells(xlCellTypeVisible).Copy
Sheet.Range(TMPCellAddress).PasteSpecial xlPasteValues
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment