Skip to content

Instantly share code, notes, and snippets.

@saykan

saykan/gist:4bc8116ce14ba982cfc24ac23b47d0c6

Created March 29, 2016 19:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save saykan/4bc8116ce14ba982cfc24ac23b47d0c6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save saykan/4bc8116ce14ba982cfc24ac23b47d0c6 to your computer and use it in GitHub Desktop.
Download ZIP
VBA - Copy and paste cells from another sheet
Raw
gistfile1.txt
Sub Copy_BL_Peers()
'
' Copy_BL_Peers Macro
Sheets("Companies and Fields").Select
Range("S2:S17").Select
Selection.Copy
Sheets("Peers").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWorkbook.Sheets("Dashboard").Activate
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment