LinkBack URL
About LinkBacks
can any1 help to send me vba code to delete all the empty lines automatically after press commandbutton using macro? pls
can any1 help to send me vba code to delete all the empty lines automatically after press commandbutton using macro? pls
Last edited by JBeaucaire; 03-16-2014 at 09:47 PM. Reason: Moved to thread of its own, as per Forum Rule #2. Please read the rules, link above in the menu bar.
What is your definition of an empty line?
Bernie Deitrick
Excel MVP 2000-2010
I mean delete te blank rows using macro ...I want to delete the rows permanently..I don wan it to overlap aftr I delete te current row...for example I hv data range a1 to a50 so I wan to delete after a50 until te last row in excel...I jus wan te data to b tere not te blank rows...can u help me
You can hide them, but you cannot delete them - they will always be there. That is just how Excel works. If you want something different, then you would need to use some other software.
I wan to compare multiple columns in single macro and highlight words that dont match...so how to this in single macro?
I have attached the sample code which I got...this code is for 2 column I need for 17 columns so pls help me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks