Hi
I am looking at importing a file that could have up to 1000 populated lines in it. there will be no empty rows in between the lines. I then need to ensure that there are 10 empty rows inserted in between every populated row. I was thinking of doing it manually and recording it on a macro.... However the issue will have with this is that everyday the number of rows will vary.
is there anyway of auto inserting 10 empty rows in between populated ones?
This little routine will add the rows on the activesheet. Add it to your existing macro or call it separately:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
BrilliantOriginally Posted by JBeaucaire
This little routine will add the rows on the activesheet. Add it to your existing macro or call it separately:
Please Login or Register to view this content.
many thanks
Try this codeCopy the Excel VBA codePlease Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.
Edit: Oops, i didnt refresh my page before posting my solution. Nevertheless, you can try both.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks