VBA Code Required

  • I want to count the color of cell column wise with given RGB's .

    For Example

    The code will count the two colors for used column across all sheets and will create summary sheet then paste the result there with sheet names and headers.

    Same as summary sheet is looking like.

  • I still don't understand what you are summarising. The attached workbook contains a VBA Function to count, average or sum coloured cells

    I'll check back tomorrow now.

  • My sheet has no code. i made the sheet manually.

    I am looking for VBA code which will count 2 color from all worksheets used Columns till last row and then paste the result in summary sheet.

    First Code will count sheet columns till last row (those cell which are colored)

    second Code will create summary sheet

    third Code will paste each sheet Header separately in summary sheet, with sheet name as i made manually in summary sheet and there count result.

    There are two colors in my sheets which i want to count that are Green and Pink and here is RGB(244, 204, 204) & RGB(183, 225, 205).

    Each sheet headers are same that are names in sheet 1 2 3 4 5 6 7 8 9 10 11 12 13 14 so on these are headers.

    I want to count how many green and pink color is in header 1 and so on.

  • I have made a summary sheet manually but want a code which will make the summary sheet automatically and paste the Green and Pink count

  • [xpost][/xpost]


    This is your final warning about the Forum Rules. I will ban you from the Forum next time.

  • Yeah Noted but any solution can given.


    Please make this code correct.

  • Yes i have seen the warning that is obviously not good at all. I was just looking for solution.

    and the thing is i have been warned for cross posting but none of the them have posted solution and comments related to post. that means post has been closed.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!