Mr. McGimpsey, I entered your code from 12/21. Some
points:
i.) I changed the row number sequence in "U51:U62... line
to all 51:62, where some were 62:51.
ii.) My computer will not allow me to capitalize the word
range anywhere in the code.
iii.) Do not receive any #Div/0! errors.
iv.) Answers are not coming up in columns "X", "AG", "AP"
or "AY".

-----Original Message-----
Did you take a look at the revised code that I provided?

http://google.com/groups?threadm=jemcgimpsey-
0F0EFB.15181821122003%40
msnews.microsoft.com

I *think* it does what you expect.

Note that, based on your earlier problem statement, and
entry in
AD19 will reference P11, not P10. Likewise, AM19 will
reference P12
and AV19 will reference P13.

In article ,
"Phil Hageman"
wrote:

Paul, thanks very much for your help - appreciate your
time. Before I go further, please know I am not a
programmer and a lot of this code I do not understand.
That said, the following:

i.) The space was added, which cleared a compile error.
ii.) .5, or 50%, is the correct answer - but I'm still
getting a blank in X19, and, #Div/0! when I make
entries
in AD19 (error in AG19), AM19 (error in AP19), and AV19
(error in AY19). Seems like it is looking in the wrong
place for the divisor (thus a blank and #Div/0!)?. The
inputs were made in the correct order.
iii.) Could this be a clue - for AD19, AM19 and AV19,
it
should not be looking in P42 or V42, rather, P10 and
V10.
.