Hello team,
I would like to ask for help with the following macro as I just can't figure it out, I tried so many versions but nothing worked for me.
I need to remove all rows in my sheet that do not contain value greater than 50 in any cell in a given row. That means that if the value is less than 50 in all cells in a row but one, I need to keep this row and to only delete it if all the cells contain values that are less than 50 or are blank. However, my range is dynamic (both rows and columns are dynamic) which is causing the main issue for me as I don’t know how to specify the range correctly. The first three columns are text only, so I need the macro to only search for values from the fourth column until the last column and from the second row (the first one is header) until the last row. I need to “count” the number of rows based on the first column as it is the only column where no cell will ever be blank, e.g. this way: LastRow = Range("A" & Rows.Count).End(xlUp).Row
What would be of extra help but is not necessary – to change interior color of cells that are greater than 50 to RGB (255, 199, 206).
Thank you very much for any advice, it will be very appreciated!
Dany
I would like to ask for help with the following macro as I just can't figure it out, I tried so many versions but nothing worked for me.
I need to remove all rows in my sheet that do not contain value greater than 50 in any cell in a given row. That means that if the value is less than 50 in all cells in a row but one, I need to keep this row and to only delete it if all the cells contain values that are less than 50 or are blank. However, my range is dynamic (both rows and columns are dynamic) which is causing the main issue for me as I don’t know how to specify the range correctly. The first three columns are text only, so I need the macro to only search for values from the fourth column until the last column and from the second row (the first one is header) until the last row. I need to “count” the number of rows based on the first column as it is the only column where no cell will ever be blank, e.g. this way: LastRow = Range("A" & Rows.Count).End(xlUp).Row
What would be of extra help but is not necessary – to change interior color of cells that are greater than 50 to RGB (255, 199, 206).
Thank you very much for any advice, it will be very appreciated!
Dany