Previous Topic Next Topic

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


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

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses