Recent content by coltaalex

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