excelvba

How to get the sheet name from Application.Caller?

It is possible to get the calling workbook name Application.Caller.Worksheet.Parent.Name and cell address using Application.Caller.Address, for a function called in Excel.

Is there a way to get the sheet name, e.g. Sheet1, using Application.Caller?

Solution

  • you pretty much had it already

    Application.Caller.Worksheet.Name