Say I have multiple non contiguous cells selected (A1, A3, A5, etc etc..) all in the same column and I want to expand them by say 10 columns. So my result will be to have selection as A1:J1, A3:J3, A5:J5 ETC..
Is there a slick way to accomplish this? I wish vba's .offset would work like it does in excel so I could say offset(0,0,0,10).
Any ideas or suggestions?
It won't let you do them all at once but you can do something like this.
Please Login or Register to view this content.
Last edited by JLGWhiz; 04-03-2019 at 09:58 AM.
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!
I tweaked to
But how do I retain each in selection as it loops through?Please Login or Register to view this content.
Incorporate union someway?
How aboutPlease Login or Register to view this content.
That works thankyou!Originally Posted by Fluff13
How aboutPlease Login or Register to view this content.
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks