Copying a Range of Cells to Another Sheet with Macro

Опубликовано: 04 Октябрь 2024
на канале: Alex C

218,939

306

This video shows how to copy a Range of Cells to Another Sheet with a Macro in Microsoft Excel 2007

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

Handy Excel Resources
https://amzn.to/3gFx7s1 - Excel Formulas & Functions For Dummies 5th Edition
https://amzn.to/3sYnuH6 - Microsoft Excel 2019 VBA and Macros
https://amzn.to/2PqXhU0 - MICROSOFT EXCEL VBA AND MACROS FOR BEGINNERS:
https://amzn.to/3xtsLtM - Microsoft Excel VBA Programming for the Absolute Beginner
https://amzn.to/3xwkEg0 - Excel 2019 Bible
https://amzn.to/3aJEHxW - EXCEL 2020 FOR BEGINNERS

Sub CopyRange()
'
' CopyRange Macro
'

'
Range("A3:M3").Select
Selection.Copy
Sheets("Sheet2").Select
Range("B3").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

Sub CopyRange2()
Sheets("Sheet1").Range("A3:M3").Copy Sheets("Sheet2").Range("b3")

End Sub