In Sheet1, Range A1:E5 I have
smith $2.00 $3.50 $4.00 $5.50
jones 6 7 8 9
roe 10 11.5 12 13
doe 14 [empty string] [blank] 15
jones 16 17 18 19
Here's the code:
The message box displays 15 13Please Login or Register to view this content.
In the rng1 loop IsNumber treats $2.00 and $4.00 as numbers, but not in the array loop.
What's up?
Bookmarks