View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edgar Thoemmes[_4_] Edgar Thoemmes[_4_] is offline
external usenet poster
 
Posts: 16
Default Entering Formula with "" within it

Hi

Try using =IF(Range1= """",Range2, Range1)

HTH


"Ron McCormick" wrote:

I am trying to write the appropriate code to enter a formula along the
following lines into a particular cell in a worksheet.

=IF(Range1= "",Range2, Range1)

I've been advised that I should use coded version of the quotes
incorporating Chr (34) - something like:

strQuote = Chr(34)
ActiveCell.Formula = "=IF(Range1= "& Chr(34) &" ,Range2,Range1)"

but I can't seem to get the syntax quite right.

Any help would be appreciated.
--
TIA
Ron