Case Method & Range Object Problem
On Apr 29, 12:26*pm, JingleRock wrote:
I guess you mean using 'WorksheetFunction.IsNA'.
Thanks very much, Joel.
I did some experimenting; first with just one expression in Case 1 and
then with all three expressions in Case 1. I discovered that if I
swapped logical ORs with logical ANDs and then swapped "<"s with
"="s, all 8 of the Cases work correctly; this is true for the 600+
securities in my wsDATA Sheet.
Thanks again.
|