How to copy a range of cells.

Closed

Raicce - Mar 19, 2012 at 06:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 03:57 PM

Hello,

How to copy a range of cells from One excel file to another excel file.

Ex: In file A, I want to copy the Cells from The Column C4 to the Last entry in that column
to file B, starting from the cell B2 (to the last entry of C4 in file A) using VBA codes...

Like this I have to do for many columns...

Please help me in this... Would be great if you give clear explanation with VBA codes...Thanks in advance

How to copy a range of cells.
Apple airtag range - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum
How to automatically copy cells from one sheet to another - Guide
Compare 2 text cells and show difference in the third cell ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2012 at 03:57 PM

you need to give more detail into issue

lastRow = Range("C" & rows.count).End(xlUp).Row

Range("C4:C" & lastRow).copy
Range("B2").pastespecial

Similar discussions

Excel if range of cell contain a text put a cell value in

Condition formatting on changing cell color based on another cel

help me to add particular cells

Applying my macro to a range of cells...

Excel Macro - Set and autofill a range?

Similar discussions

Subscribe To Our Newsletter!