| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replacing varaibles in formula
I have "G:\04 Assembly Cost\+06 FY
03_04\TCR2003_Assembly_0305.xls" in a variable path1 and the worksheet name "TCR2003 by packages" in another variable "wkshName". how can I replace the 'G:\04 Assembly Cost\+06 FY 03_04\[TCR2003_Assembly_0305.xls]TCR2003 by packages' in the vlookup formula below by the variables path1 and wkshName??? Cells(rowSt, z) = "=( VLOOKUP(" & Cells(rowSt, packRng.Column).Address & ",'G:\04 Assembly Cost\+06 FY 03_04\[TCR2003_Assembly_0305.xls]TCR2003 by packages'!$B$4:$G$251,4,FALSE)" & ")" Thanks monika |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing ISERROR Formula | Excel Worksheet Functions | |||
| help on replacing this formula | Excel Discussion (Misc queries) | |||
| replacing text within a formula | Excel Worksheet Functions | |||
| Replacing a value from a formula | Excel Programming | |||
| Replacing DirectPrecedents in a Formula | Excel Programming | |||
Threaded Mode
