Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
substitute strings with variables
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBSTITUTE multiple text strings | Excel Discussion (Misc queries) | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
Complex Text Strings|Variables | Excel Programming | |||
Converting strings to Sum worksheet function and control variables | Excel Programming |