I tried to do this via Autofilter, but it seems that I'm having problems there and the people that wanted to help couldn't really view my file...
So assuming the following:How can I sort range(cells(2,1), cells(LR1,LC1) by column NC4 ("Status"), then delete all rows that have 9 in Column NC4?
Please Login or Register to view this content.
Trust me I've tried AutoFilter several times, look at the thread linked here and you'll see that it hasn't work... And loops took forever, > 30 mins
Thanks,
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks