How to get the sheet name from Application.Caller?

Question

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?

Answer 1

you pretty much had it already

Application.Caller.Worksheet.Name