Working my way through the Excel VBA for dummies book which is quite fun, inputting one of the exercises as follows:
This works just as I'd expect it to. I then decided to spice it up a little as follows:
This, sort of does as I'd expected but returns FALSE in K14 rather than the total of the random numbers. Can someone please explain to me what I'm doing wrong?