Disclaimer: I have no idea what I am doing with VB; I work in the C family.
Currently we have excel workbooks in which specific rows need to be deleted (skip 2, delete 3).
I spaghetti'd this together and it seems to be working:
When run, this works as I want it to.
Please Login or Register to view this content.
However, when flipping statement comments (eg, comment out the BG change and uncommenting the row deletion), it gives me wildly inaccurate deletions.
Anyone know what I am doing wrong?
Delete from the bottom up :-)
For Cnt = 505 to 1 step -1
You might need to adjust your logic ... maybe, step -5
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Excellent, thank you. I didn't realize you could do that, maybe VB isn't so horrible after all.Originally Posted by TMShucks
For anyone who is interested, this is the working code. (I hate googling & finding these posts with no solution posted at the end.)
Please Login or Register to view this content.
Last edited by mtfd; 01-13-2011 at 11:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks