I was following steps on how to use Get.workbook(1) in order to create an index of sheet names. The first step was to make a named range so the function can be used. Then I entered the named range into a cell and pulled down the cell. instead of the sheet names it has displayed all the sheet names as vol, rather than sheet 1 or sheet 2 etc.
can anyone help? Many thanks
Hi,
I posted this problem and since then I have solved the problem I had. I decided not to go for automatic links in the end and i didn't need get.workbook formula. i used hyperlinks instead.
Many thanks for putting it on the forum
It returns an array, so you either need to array enter it into a range of cells at once, or use INDEX with it:
=INDEX(named_range,1)
for example.