INDIRECT function doesnt work

[GedSalter]

Hi,

I have a column B which contains numbers. These numbers correspond to worksheets in the workbook. I need to create a macro so that when activated will open the relevent worksheet in column B.
I have hundreds and would take a long time to set a hyperlink to each one when the worksheet is created.

Is there a VBA for this. I found the INDIRECT funtion doesnt work in VBA.

regards

Ged

 

[DanteAmor]

What do you need?
Select a cell with a sheet number, press a button and have the macro take you to that sheet?

 

[GedSalter]

the sheet number is variable. Its whatever is in a cell in column B

 

[DanteAmor]

Okay. Forget my comment.
But what do you need?

 

[petertenthije]

Did you remember to include the apostrophes and exclamation mark?

The format should be: ‘Sheetname’!A1