Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. coltaalex

    Delete question pop window

    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...
  2. coltaalex

    Macro - transpose - audit

    Thank you very much Bong
  3. coltaalex

    Macro - transpose - audit

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

    Macro - transpose - audit

    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...
  5. coltaalex

    how to stop at the lastrow

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

    how to stop at the lastrow

    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)
  7. coltaalex

    how to stop at the lastrow

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

    how to stop at the lastrow

    of column 14 Which is N , stating from row 11
  9. coltaalex

    how to stop at the lastrow

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

    how to stop at the lastrow

    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
  11. coltaalex

    how to stop at the lastrow

    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,
  12. coltaalex

    how to stop at the lastrow

    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...
  13. coltaalex

    how to stop at the lastrow

    yes, right ,
  14. coltaalex

    how to stop at the lastrow

    ok , it is selecting the whole sheet
  15. coltaalex

    how to stop at the lastrow

    i have 2007
  16. coltaalex

    how to stop at the lastrow

    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 ?
  17. coltaalex

    how to stop at the lastrow

    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...
  18. coltaalex

    How to highlight conditional formatting

    i fount it , thank you very much !!!
  19. coltaalex

    How to highlight conditional formatting

    , how can i do it in excel 2007
  20. coltaalex

    How to highlight conditional formatting

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

Part and Inventory Search

Back
Top