Collecting Row location based on multiple Worksheet Change Event

[zoog25]

Hello all,

Here is my situation,

I'm currently using worksheet_change event for Column F. I have set the target to Column F

Set R = Intersect(Target, Range("F:F"))

This run one set of coding for the event when something happens in column F.

Now i want to run code that counts the filled cells in the same row but between Column K : V if Column A will Pub or between K : Y if Column A will Priv.

Column A gets gets filled when Column F change event happens.

Please let me know what i can do or where i can get started. Thank you.