If I end the code with End Sub I get an error message that the program was expecting End With. When I use End With the program was expecting End Sub.
Also within the following code can someone tell me exactly and only which lines to take out so the macro will stop counting empty cells. I only need to delete duplicate rows.
Please Login or Register to view this content.
Last edited by dalewms2; 10-13-2011 at 03:10 PM.
dalewms2,
You should be able to use the following to delete duplicates while ignoring blanks:
Please Login or Register to view this content.
Last edited by tigeravatar; 10-13-2011 at 03:14 PM. Reason: User corrected code tags
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Your code tags are messed up, please correct.
Your attached file does not have any code in it.
I pasted your code above and it compiled and ran fine with no errors. Here is the (correctly formatted) version of what I actually ran:
I don't understand your second question. This code does not count empty cells.Please Login or Register to view this content.
Subs will always end with "End Sub", so that should always be there. What the error is telling you is that there is a With statement that does not have an End With. Since there is no With statement in your code, I can only assume that the problem lies elsewhere. I copied your code into a blank workbook and it compiled just fine. I threw together some dummy data and it ran fine for that as well.
Can someone tell me what's wrong when you open a spreadsheet and the macro is no longer there. I even opened the spreadsheet I attached to this question.
My guess is that you saved it as an .xlsx and then saved it as a .xlsm.
Same macro. Different workbook. I am now getting a run time error 438 Object doesn't support this property at the point I highlighted below.
Please Login or Register to view this content.
And this is why you should provide all your code.
Here is your missing End With:
As for your error, your highlight does not show in a Code box. Please call the specific line out in its own code box.Please Login or Register to view this content.
This is the code that gives the error
Please Login or Register to view this content.
This error is due to your missing End With I pointed out in my previous post.
The sub is still in "With .Sort" mode, so
is reallyPlease Login or Register to view this content.
Which is wrong.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks