Search:

Type: Posts; User: Jpngineer; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: VBA Code, how to define range of found column header properly

    I changed the ColorInde to Color.
    No error occurred but the matched data was not highlighted.

    What do you think was lacking with the code?



    Thank you as always.
  2. Re: VBA Code, how to define range of found column header properly

    What does it mean?
    Sorry, I am really a newbie.

    I also used below code as an alternative, actually this is what I am trying to do as a whole but the error occurs at For-Each If c1=c2 line

    ...
  3. Re: VBA Code, how to define range of found column header properly

    For sheet2 it is in row2.
  4. Re: VBA Code, how to define range of found column header properly

    I mean it errors on line50
  5. Re: VBA Code, how to define range of found column header properly

    Thanks for answering,
    However when I tried, it errors after dwg_y = Range(SYM_COL, SYM_COL.End(xlUp)).EntireColumn

    I don't know why.
    Error 1004 Application and Object Error

    Thank you so much.
  6. VBA Code, how to define range of found column header properly

    AC


    AD

    AE

    AF

    AG
  7. Re: How to find column via header name, then compare that column with another worksheet and highlight the difference.

    Hi,

    Thanks fo entertaining my question. I really appreciate it.

    This is what i need to be done.
    I have two sheets.
    datax and data y wich contains many columns and rows.

    I need to compare...
  8. Re: How to find column via header name, then compare that column with another worksheet and highlight the difference.

    I got the title wrong..
    It should be *Highlight the SIMILARITIES.
    Thanks
  9. How to find column via header name, then compare that column with another worksheet and highlight the difference.

    I am a newbie here, also a newbie in VBA.

    I have two worksheets that I wanted to compare.

    Let's say,

    Sheet1
    Column DWG. NO
    Column SYM
    Sheet2
Results 1 to 9 of 9