I have the following two problems:
1. I want to substitute the string "A_030716_cl_max_val_EK" with
variable (filestringL) that contains this string. How can I do tha
(see statement following)?
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:
"A_030716_cl_max_val_EK!R1C1:R74C11").CreatePivotT abl
TableDestination:="", _
TableName:="PivotTable2"
DefaultVersion:=xlPivotTableVersion10
2. I want to substitute in the following statement the 9000 with a
integer that contains the value. Any ideas?
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(Members,
Code
-------------------
s Sheet1'!R2C1:R9000C7,5,0)"
Thank you in advance.
G
--
Message posted from
http://www.ExcelForum.com