Search results for query: *

Hi all I have a file with 10 sheets in it. I want to delete 4 of them, so i recorded a macro with selects the sheets ( which i want to be deleted), but when i run it, a warning message comes up asking if i want truly to delete the sheet, how can i take that warning window out ? Here what i...

Thank you very much Bong

No, because i have to create a column from the diagonal rows

Hello experts in VBA excel. I have a excel sheet, with which my coworker collects data from the different audits, he is collecting it on diagonal form (upper left to bottom right), because the columns and rows content is changing all the time ( data collection) So i would like to create a...

Thank you Skip for all your help and support Have a great evening,

now i have to analyze and the bottom i can add my message box code ? and i see you did just the fist CF rule ( count if) the same thing i have to do for the second rule ( TRIM("N11")=0)

columns: 14,15, 16, 17, 18, 19, 23, 24, 25,

of column 14 Which is N , stating from row 11

my concern is that CF is applied to the 3 cell , it suppose to stop at the first empty cell

Skip i don't have any formula, in these cells,, i introduce by hand all the codes, the code is combination of some letters and numbers , like: CFT8-100

it the same code just the instead of 16 now is 14, because i have to use CF for several columns, but methodology is the same,

i have data just in the first 2 cells, and in the cell 4, so CF suppose to color the cells 1 and 2, ad stop at 3, because 3 is empty, now it is coloring also the 4 cells. Here is my full code, it has tow CF rules, first is checking the duplicates numbers , and second one is coloring in white...

yes, right ,

ok , it is selecting the whole sheet

i have 2007

Skip can you please explain me how your code is stopping the conditional formatting ? Sorry for disturbing you so much , what condition did you use to stop the code ?

how to stop at the last row selection "R11C14:R10000C14" I have a sheet where i have a column with data, number of row every time is different, some time i have less data some times more, how can i stop my conditional formatting at the last row of data every time the code is going until...

i fount it , thank you very much !!!

, how can i do it in excel 2007

PHV , why color index =8 ? i have different colors, Thank you !!