View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_3_] Phil Hageman[_3_] is offline
external usenet poster
 
Posts: 160
Default Which code to use?

Mr. McGimpsey, Nice to hear from you again. Am I
confused here! I thought this was your code (from 12/21),
as modified by Tom Ogilvy. Should I enter your code,
dated 12/21, 2:18:18, vs Tom's? Sorry this is getting so
confusing...
Thanks, Phil
I tried to come up on the below url, and Google could not
find it.

-----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.
.