issue with "if" statement in array

[mbydl2]

Hi everyone,
I have this code below which works perfectly until I add the if statments. For reasons that I don't understand days 7, 8 and 9 return 0 values for ar(p,5) even though they should be 1 and any value above 99 days is doing the same thing.
Any idea as to why this might be? what can I do to solve this?

(by the way, i'm super new to VBA)

Thanks

Please Login or Register  to view this content.

[AlphaFrog]

The results in your array are text. Not numeric values

Change this...

Please Login or Register  to view this content.

To something like this...

Please Login or Register  to view this content.

[mbydl2]

awesome! thank you so much

[AlphaFrog]

You're welcome. Thanks for the feedback.