Insert this line to your code
Range("B3:B100").Copy Destination:=Range("C3:C100")
The range destination can be changed depending on which range you want to paste the data.
More Related Contents:
- How do I get values from a hidden worksheet using VBA [closed]
- How to copy cells that contain certain text to another worksheet [closed]
- Get all dates between 2 dates in vba
- Different languages issue when inserting formula from VBA
- vba: get unique values from array
- Unprotect VBProject from VB code
- Can VBA Reach Across Instances of Excel?
- Excel VBA – Delete empty rows
- Efficient way to delete entire row if cell doesn’t contain ‘@’ [duplicate]
- Building Undo Into an Excel VBA Macro
- Excel vba add code to sheet module programmatically
- Best workaround for VBA Transpose array length limit?
- How to Lock the data in a cell in excel using vba
- How to use Events with Option Button Controls on Userform [duplicate]
- How do I use variables to set properties in VBA (Excel)
- VBA: Else without If Error
- Workbooks.Open Method in VBA
- Windows().Activate works on every computer except one
- How to highlight a cell using the hex color value within the cell?
- Convert RTF (Rich Text Format) code into plain text in Excel
- lastrow and excel table.
- Open a workbook from VBA and disable Workbook_Open() code?
- Creating form programmatically in the module using vba
- How to filter listbox values based on a Textbox value
- Is there a way for DIR(path) in VBA to handle strings longer than 260?
- How do I activate a specific workbook and a specific sheet?
- Start VBA macro when editing a cell
- VBA Run-time error 438 appears when “paste” runs
- If Not function proceeds when value *is* the one specified
- Copy an entire worksheet to a new worksheet in Excel 2010