View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
JingleRock[_2_] JingleRock[_2_] is offline
external usenet poster
 
Posts: 45
Default 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.