| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - applying macro to all files in folder
jrc
"=LOOKUP(""370302"",'[sFName]'!R2C2:R1308C2,'[sFName]'!R2C18:R1308C18)" Range("I9").Select ActiveCell.FormulaR1C1 = _ "=LOOKUP(""370302"",'[" & sFname & "]'!R2C2... sFName is part of your string so Excel is putting it literally in the formula. By concatenating sFName in the string, Excel will evaluate the variable and put the actual name in the formula. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro creating folder and files automatically, without permission. | Excel Discussion (Misc queries) | |||
| Macro to create a folder and copy files | New Users to Excel | |||
| Path and Number of files in a folder. - Pass to Macro. | Excel Discussion (Misc queries) | |||
| Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
| Macro to Print All Files in a Folder | Excel Programming | |||
![Dick Kusleika[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
