Incorporate (xlCellTypeVisible) into For..Next loop

[Gard5096]

Hello,

I am trying to make the loop only count the visible cells when it measures the max value. Any assistance would be very much appreciated. I attached the document.

I'm not sure where to place the property within the following part of the code:

Please Login or Register  to view this content.

Here is the entire code:

Please Login or Register  to view this content.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

Or this formula in WORK!C3 and copy down...
=MAX(INDEX(REPORT!D:G,MATCH(A3,REPORT!A:A,0),0))

[Gard5096]

AlphaFrog,

Thank you, that loop worked amazingly. Another problem did arise after the execution. Some of the rows dont have any dates, and the result is coming up as "1/0/1900". Do you know how I could display text of "N/A" for rows that have all blanks?


Thank you,

Nick

[AlphaFrog]

You're welcome.

Try this...

Please Login or Register  to view this content.

[Gard5096]

Yessss!!! Thank you very much.