vbacoder
Active Member
- Joined
- Jul 7, 2007
- Messages
- 354
Hi everyone,
I'd be grateful if someone could show me an example of Harlan Grove's PULL function works for a path reference that has been formed from components in several cells:
A1 = " 'C:/work/"
B1 = "data
C1 = "[ClosedBook.xls]Sheet1'!$A1"
D1 = A1 & B1 & C1
I have tried E1=PULL(D1), to obtain the value in the cell referenced in D1, but it doesn't work, and the way the argument is passed to the function is not very clear from the instructions on the page where the code is posted:
http://groups.google.co.uk/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd
Many thanks.
vcoder
I'd be grateful if someone could show me an example of Harlan Grove's PULL function works for a path reference that has been formed from components in several cells:
A1 = " 'C:/work/"
B1 = "data
C1 = "[ClosedBook.xls]Sheet1'!$A1"
D1 = A1 & B1 & C1
I have tried E1=PULL(D1), to obtain the value in the cell referenced in D1, but it doesn't work, and the way the argument is passed to the function is not very clear from the instructions on the page where the code is posted:
http://groups.google.co.uk/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd
Many thanks.
vcoder
Last edited: