How to copy a range of cells.

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you need to give more detail into issue

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

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