Hello everyone.
I have a report that I import from a program, but every time I export to excel, it skips lines.
What would be the code to remove empty rows from it?
Thanks in advance!
Hello everyone.
I have a report that I import from a program, but every time I export to excel, it skips lines.
What would be the code to remove empty rows from it?
Thanks in advance!
Last edited by sentinela; 02-03-2010 at 11:10 AM.
1) Highlight one column, perhaps column A
2) Press F5 and click on SPECIAL
3) Select BLANKS
4) Click OK
5) Click on EDIT > DELETE > Entire Row
Or....
![]()
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!)
Hello JBeaucaire
Thank you very much for sharing this code with me.
It works great for my needs.
Thank you so much again!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks