ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   copy colomn by code (https://www.excelbanter.com/excel-programming/340424-copy-colomn-code.html)

nowfal[_57_]

copy colomn by code
 

Hi,
I wanted to copy 3 colomns that begins from A2,B2,C2 to till the en
of the colomn having data, it varies always(sometimes it may have upt
A54,B54,C54 or sometimes may upto A10,B10,C10). so, please help me t
write the line of code.
thanks
regards
nowfal

--
nowfa
-----------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000
View this thread: http://www.excelforum.com/showthread.php?threadid=46864


duane[_54_]

copy colomn by code
 

I assume you want vba code

range(cells(2,1),cells(2,1).end(xldown)).copy

to copy a2 thru end of data in column

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=46864



All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com