Hi could someone point me in the right direction of where I am going wrong, I want to run through column B and if the cell is coloured Red then delete that row, I have the below code which seems to run through each cell but doesn't delete the row? Any help would be much appricated
Please Login or Register to view this content.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Ok its still not quite working, ive added the line before it aswell, im adding a conditional format to change the cell color to 255, then it wont delete them, if I manually go in and change the colour to 255 then the code works, so it seems that the condition format is not changing the color correctly??? im really confused now.
Please Login or Register to view this content.
Use the condition you are using in rge conditional formatting to determine whether or not to delete a row.
If posting code please use code tags, see here.
That work perfectly, im not to sure why the other way didn't work but this is much better any way.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks