Using Code names in formulas
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
|