ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 803
- Office Version
- 365
- 2019
- Platform
- Windows
Hello - having some trouble putting an indirect formula together to pull my formulas. Case scenario is my A2 could change so I need it to reference off a cell. But my B2:C2 i want to set them as fixed in the path. I keep getting the below error, is there something I am doing wrong?
Book2 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Workbook Path | Fixed File Name | Cell Range | ||
2 | C:\Users\Marco\Desktop\ | VBA TESTING.xlsm | J:L | ||
3 | |||||
4 | #NAME? | ||||
5 | |||||
6 | Desired: | [VBA TESTING.xlsm]Sheet1'!$J:$L | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A4 | A4 | =INDIRECT("'["&A2&VBA Testing.xlsm&"]"&"Sheet1"&"'!"&"J:L") |