Forum

Notifications
Clear all

Get.workbook(1) problem

3 Posts
2 Users
0 Reactions
270 Views
(@canada1962)
Posts: 2
New Member
Topic starter
 

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

 
Posted : 10/03/2021 9:00 am
(@canada1962)
Posts: 2
New Member
Topic starter
 

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

 
Posted : 10/03/2021 10:35 am
(@debaser)
Posts: 837
Member Moderator
 

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.

 
Posted : 10/03/2021 10:36 am
Share: