Suarez0523
New Member
- Joined
- Apr 29, 2008
- Messages
- 13
Hello community,
I am stumping over a problem this afternoon. I have the following formula in my Sub:
I would like to be able to replace TestClient with a string variable. I have tried using an indirect function with no luck. I also tried concatenating it, but no luck either.
Any thoughts?
I am stumping over a problem this afternoon. I have the following formula in my Sub:
Code:
ActiveCell.FormulaR1C1 = _
"=GETPIVOTDATA(""Hours"",'[TestClient.xls]Pivot Table'!R3C1,""Department"",""Client Services"")"I would like to be able to replace TestClient with a string variable. I have tried using an indirect function with no luck. I also tried concatenating it, but no luck either.
Any thoughts?
