Count rows and run different macros based on result

[Chanty]

I need to open various files and depending on the count between cell A1 (value = Identity) and the next instance of (Identity) - in the example attached the count would be 20, as the second instance of Identity is row 21. I then need - if the count equals 20, run macro1 - if the count equals 21, run macro2 etc...

Many thanks for your help

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...unt-value.html