Hi folks,
I am trying to insert 50 blank columns in between each id. What methods should I use?
Thanks very much.
Hi folks,
I am trying to insert 50 blank columns in between each id. What methods should I use?
Thanks very much.
Do you mean rows?
If posting code please use code tags, see here.
Sorry, Yes, i mean rows.
if you are looking for vba code try this
![]()
Sub myTest() Dim mycel As Range Dim lr As Long lr = Cells(Rows.Count, "g").End(xlUp).Row For i = lr To 9 Step -1 If Cells(i, "g").Value > "" Then Cells(i + 1, "g").Resize(50, 1).EntireRow.Insert End If Next i End Sub
Last edited by venkatpvc; 12-30-2013 at 03:09 PM.
Give Feedback and Click(*)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks