Good Morning
I have data in the sheet, production, management, information and I want to separate them by putting a blank line when it ends the column concerning production, blank line to separate production management ......
Thank you
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
insert blank line
0
Discussion
with vba code
MJFernandes Oct 4, '18 at 4:44 am
The workbook you posted looks like you are trying to do your homework. I might help you learn if you don't ask me to do the work for you. For now, I can't find the rows for "production" and "management", not even the sheet which you might refer to. Also, on the type of sheets in your workbook one wouldn't use VBA to insert rows. It's faster and easier just to select a row, click Insert (on the ribbon's Home tab) and select Sheet Row. VBA would be advantageous where a row must be inserted repetitively, for example, whenever the entries in one row have been completed.
Note that, rather than using the Discussion section, you can modify your original question to clarify what you would like to have explained.
Note that, rather than using the Discussion section, you can modify your original question to clarify what you would like to have explained.
Variatus (rep: 4889) Oct 4, '18 at 5:12 am