bamaisgreat
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 834
- Office Version
- 365
- Platform
- Windows
I have searched for this and have not come up with anything.
I have 2 workbooks, 1 named "Main Workbook" and another called "Public Workbook"
is there code that can be but into sheet 1 of the "Public Workbook" that will do the same as a formula such as this
='[main book.xls]Sheet1'!$A:$N
I have 2 workbooks, 1 named "Main Workbook" and another called "Public Workbook"
is there code that can be but into sheet 1 of the "Public Workbook" that will do the same as a formula such as this
='[main book.xls]Sheet1'!$A:$N