Hi rlangley936,
If you want to insert copied cells, you can use the keyboard shortcut
- Ctrl+Shift+V
. This will bring up the
Paste Special dialog box, where you can choose to insert the copied cells as
- values
- formulas
- formatting
, and more.
Alternatively, you can also
right-click on the cell where you want to insert the copied cells, and select
"Insert Copied Cells" from the context menu.
Code:
Formula:
//Insert copied cells
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False