personal.xlsb macro fails to run

[Grigoriy]

Hello, help is needed:
The following function:
>>> use code - tags <<<

Public Function IndirectNotVolatile(sheetName As String, sheetRange As Range) As Variant
Set IndirectNotVolatile = Worksheets(sheetName).Range(sheetRange.Address)
End Function

has been recorded into a personal.xlsb and FAILS to run on excel's [.xlsx], [.xslb] files.

 

[Debaser]

What happens?

 

[Grigoriy]

The function IndirectNotVolatile does not appear in the list of functions and does not work.

 

[p45cal]

It will not appear in the list of functions because it needs arguments.
It might work on worksheet but you might need to prefix it, eg.:
=PERSONAL.XLSB!indirectnotvolatile("smith",G13:J17)
See https://stackoverflow.com/questions/31815205/use-personal-xlsb-function-in-new-workbook

 

[Grigoriy]

It worked!
Thank you a lot.