Hi,
We want to copy Sheet1!B2:B4 in to Sheet1!B5:B7
same again, till 43 times
we want to do this through VBA
help pls
Hi,
We want to copy Sheet1!B2:B4 in to Sheet1!B5:B7
same again, till 43 times
we want to do this through VBA
help pls
Last edited by Ajay45822; 02-03-2021 at 12:06 PM.
Or you could just manually select the range then use the mouse pointer to grab the corner and drag down as far as needed to fill the column.Please Login or Register to view this content.
Last edited by JLGWhiz; 02-03-2021 at 03:13 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks JLGWhiz JLGWhiz
its working
Hi, we have a query
when we try for B2:B4, its perfect
and also when we try for B2:B5, its working
But when we try for B2:B7, its not working
may i know the reason, it will help me modify the formula as per my need
o.k.,
find the solution,
not required reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks