VBA Code For CountIF Formula Util the Last Row We Used

Zayar Lwin 1 Reputation point
2021-06-24T03:20:05.367+00:00

Dear Sir,
I am try to count the cell data base on Column C & D. Fortunately , I found the CountIf Formula for this. I am using VBA for my test and I want to write it in VBA Code. I want to try the code utile the last used Row cause I held many amount of data. Thanks you so much.108840-countif.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,399 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Anbuselvam Kovilmani 41 Reputation points
    2021-06-30T05:17:44.577+00:00

    Column "C" and "D" You have a data from row 2 to 7. Then how the formula analyse C10, C14 and D10, D14 Datas?

    Attach a sample file or link with exact explanation of what you want?

    0 comments No comments