USer defined functions
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
|