I think she means the worksheet's codename, not a variable value. Check
Dave's response to see how it works.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"ducky" wrote in message
ups.com...

Barb Reinhardt wrote:
I've asked this elsewhere, but thought I'd put it up for more to see.

I have the following formula in my code:

Cells(i, "E").FormulaR1C1 = _
"=SUMPRODUCT(--('TESTING WORKSHEET'!R13C4:R20C4='Detail
Worksheet'!RC2),('TESTING WORKSHEET'!R13C18:R20C18))"

The code name for "TESTING WORKSHEET" is "TEST" and the code name for
"Detail Worksheet" is "DETAIL". I want to use the codename in the
formula.
How do I do this?

Thanks,

When you say code name, i think you mean variable. if that is what you
are trying to accomplish, you need to put your names into a string
variable. something like this:

dim TestWS as string
dim DetailWS as string
'make sure that you assign these variables a value at some point. then
to step in and out of the formula, it would look like this:

"=SUMPRODUCT(--('" & TestWS &"'!R13C4:R20C4='" & DetailWS & "
'!RC2),('" & TestWS &" '!R13C18:R20C18))"


hope this helps

AR