LinkBack URL
About LinkBacks
Hi, can you please post here the macro code that doesn't shift the deleted duplicates? because i need the blank cells. Thank you very much!
Hi, can you please post here the macro code that doesn't shift the deleted duplicates? because i need the blank cells. Thank you very much!
Last edited by arlu1201; 07-16-2013 at 08:05 AM.
If you look in macro code, it doesn't actually delete them, it simply clears the cells, thus creating blank cells all through the data. But near the end of the macro is a SORT line of code that sorts the data, this would move all blanks to the end, making it look like they were deleted.
To have it NOT do that, just remove the line of code that does the SORT. You'll probably want to delete the MsgBox at the end, too.
_________________
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!)
Thank you very much for the answer JBeaucaire !
Sorry but i lost the page of where you posted the code... can you repost here please? Thank you again!
THe original thread: http://www.excelforum.com/showthread...=1#post2176803
Thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks