LinkBack URL
About LinkBacks
Hello Everyone,
I am looking for a macro to delete balnk rows. I have copied data into excel and when doing so, it adds a blank row. The data set goes from row 1 to 5,000 and I want to delete the empy ones for sorting. Any help would be appreciated!
Hello Everyone,
I am looking for a macro to delete balnk rows. I have copied data into excel and when doing so, it adds a blank row. The data set goes from row 1 to 5,000 and I want to delete the empy ones for sorting. Any help would be appreciated!
Last edited by yamadogr1; 01-29-2014 at 01:34 PM.
Hello and welcome to the forum. I hope the following macro does the trick for you.
Please Login or Register to view this content.
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
Thank you very much.. It worked perfectly!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks