Hi Paige,

This works for me:

Worksheets("B").Range("B10").Formula = _
"=if(A!RANGE1=12,""this is a Test"",0)"

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"Paige" wrote in message
...
Example: I have one file with 2 worksheets (A and B). I want to have the
following formula in cell B10 of worksheet B: If range name RANGE1 on
worksheet A = 12, then insert the following text - "this is a test";
otherwise, insert a 0.

I had:
Worksheets("B").Range("B10").Formula = "=if('A'!RANGE1="12","this is a
test",0)"
but kept getting error messages. Tried with and without all types of
quotes
and multiple other things, but still got various error messages like
application defined error, syntax error, or range property, etc.

Am I reference this correctly (obviously not). Also, where would this
go -
into the module for worksheet B? What type of declaration (calculate?); I
may not have that correct either (tried all different kinds).

Appreciate any help that can be provided. Thanks.