View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Passing string arguments that have quotation marks in them

Guess you need to modify your code to account for the possible existence of
embedded double quotes.

without seeing your code, there isn't much else that can be said.

--
Regards,
Tom Ogilvy

"Caro-Kann Defence" wrote in
message ...
Hi.

I have a function that builds and evaluates an array formula SUM(IF based

on
a number of arguments. Some of these arguments are string values that may
have "" within them.

For example, I might have an item number description (one of the

arguments)
that looks like this: "Left side "H" Bracket".

The function works fine for every item except items with this type of
description. I'd like to avoid requiring users to remove the "" in the
description if possible.

Can anyone help me out?

Thanks!