I need to delete the entire row that includes a cell with a red background. For instance, if cell G7 is the only cell with a red background then I want the entire row 7 deleted AND moved up.
-A1:W25,000 (All of these cells have integers in it)
-I already run a macro to fill a cell red as needed based on my reason (NO CONDITIONAL FORMATTING USED HERE)
-I need any row with 1 or more cells, with the color red, to be deleted and moved up.
Thanks in advance for your help!!!
-Altan
Hi,
One way,
Please Login or Register to view this content.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
hi, aorum, can you post sample workbook showing original data and the result you need (10-15 rows will be sufficient)
please check attachment, run code "test"
Hello aorum,
Here is another fast method.
Please Login or Register to view this content.
Last edited by Leith Ross; 05-14-2011 at 04:25 PM. Reason: Added Application.ScreenUdating code
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks