Counta in VBA with If and & else condition

I am trying to create a VBA macro for my data using "If", "And" & "Else" Condition and for condition else I want to use counta formula with a range? How to use that?

In selected range data has dates. If there is any other option to have "And" condition that date as data has around 2000 lines with almost 1600 have dates and rest are blanks?

  Abhishek Chauhan

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any