Hello everyone!
I have a list of values:
Col A
A
B
C
D
.
.
.
Z
Is there a way to insert 7 blank cells after each value, and then copy the value downward?
Thanks!
Hello everyone!
I have a list of values:
Col A
A
B
C
D
.
.
.
Z
Is there a way to insert 7 blank cells after each value, and then copy the value downward?
Thanks!
With vba
![]()
Please Login or Register to view this content.
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!
Up until today, this solution was working perfectly. Now it only copies the last value and repeats it 7 times, not doing the same for the rest of the list. Any ideas what could have happened?
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks