saykan
saykan
/ gist:4bc8116ce14ba982cfc24ac23b47d0c6
Created
March 29, 2016 19:16
VBA - Copy and paste cells from another sheet
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 _ |