I need to refer to the cell in which my user defined function has been
entered into. i only know how to use ActiveCell to refer to things.

What other ways are there to reference objects.

Specifcally I am using a formula to print the worksheet name in some cells.

Funtion WS()

WS = ActiveCell.Worksheet.Name

End Function

Hi Scooter,

Look in VBA help for the Caller property and look at the given example.

---
Regards,
Norman



"scooter" wrote in message
...
I need to refer to the cell in which my user defined function has been
entered into. i only know how to use ActiveCell to refer to things.

What other ways are there to reference objects.

Specifcally I am using a formula to print the worksheet name in some
cells.

Funtion WS()

WS = ActiveCell.Worksheet.Name

End Function