View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default inserting formula


NickH wrote:
Ah, I see what you're getting at now.

I would say they are paired something like this...

1 & 20 These quotes embrace the whole formula
2 & 3 are embracing - & lprevsumrow & - which is a variable hence
the need to interrupt the string
4 & 7 embracing "" and telling the code to interpret the quotes
within as text NOT an instruction to break out of the string
8 & 9 again embracing - & lprevsumrow &
10 & 11 same again
12 & 15 "d" - same as 4 & 7
16 & 19 "" - same as 4 & 7 again

Kind regards,
NickH


I'm not sure of this. Particularly about enclosing the whole thing in
quotation marks. In my limited past experience, anything in ampersands
should NOT be in quotes, because it's already text by definition. But
I'm not sure of any of this. Does anyone have a lot of experience with
this and can clarify?