ThisWorkbook mac vba not working

Question

I have the following vba code which is part of a user defined function, which I am trying to run on my mac:

Function Parent(NodeID As String)

Dim c As Integer

Dim r As Integer

Dim i As Integer

Dim wb As Workbook

Dim ws As Worksheet

wb = ThisWorkbook

ws = wb.Sheets("Hierarchy-Extended")

The function stops at the first line, i.e. "wb = ThisWorkbook" and in the watch window the value for wb becomes <out of context>

Can anyone help?

Thanks

Answer 1

You need:

set wb=thisworkbook