Hi Sir,
I created a macro as below trying to delete rows which has empty spaces "" in column A. But the macro failed to work properly.
Can you have a look please? I attached the example file here. Thank you a lot.
Please Login or Register to view this content.
Last edited by alice2011; 08-25-2015 at 08:06 AM.
Hi Alice,
Try this (initially on a copy of your data as the results cannot be undone if they're not as expected):
HTHPlease Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hi, Trebor76. Your macro really works perfectly. I was a bit struggling to to make some code similar to yours, but cannot get around the errors. Now you taught me how to use array and range. Thank you very much.
Alice
Hey Alice, at first I thought this was simple and it probably is but as the rows are deleted then so the cell (c) is affected because the range that has been set has changed. Therefore a quick way around this was to put in a recursive routine maybe not the most elegant but it appears to work.
Please Login or Register to view this content.
That is why I set the calculation method to manual (then back to its original setting at the end of the routine).then so the cell (c) is affected because the range that has been set has changed
You're welcome. If you could mark the thread as solved it would be appreciated.Hi, Trebor76. Your macro really works perfectly. I was a bit struggling to to make some code similar to yours, but cannot get around the errors. Now you taught me how to use array and range. Thank you very much.
Regards,
Robert
Many thanks, Catman50. It really helps me. Good learning.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks