LinkBack URL
About LinkBacks
Case is that:
I have two Ranges. both are Single columned
1- Range("A1:A10")
2- Range ("B20:B25")
I want to copy and paste them one after one into my bigger Range - Range("C1:C40")
-looping not prefered-
Any Experts to Help Me?
Thanks,
How to Copy Multiple Single Column Ranges & Paste them in a single column range - VBA
Case is that:
I have two Ranges. both are Single columned
1- Range("A1:A10")
2- Range ("B20:B25")
I want to copy and paste them one after one into my bigger Range - Range("C1:C40")
-looping not prefered-
Any Experts to Help Me?
Thanks,
Last edited by fulan; 05-19-2020 at 08:50 PM.
One way...
OR
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Sintek; 05-18-2020 at 07:43 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Hi Sintek,
Thanks for your reliable answer, it works, for me, like a charm.
But could i ask for another solution without looping and Range.copy method.
I am not only Curious. but I really wanted throughout my code to avoid them.
and I wont ask for more
Hope You will Reply Soon,
If your ranges are truly fixed as you show, then this would work...
Please Login or Register to view this content.
Last edited by Rick Rothstein; 05-20-2020 at 03:45 AM.
I really wanted throughout my code to avoid them.Avoiding loops and copy in VBA coding...good luck with that lol...I want to copy and paste them one after one
Last edited by Sintek; 05-20-2020 at 05:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks