View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scooter Scooter is offline
external usenet poster
 
Posts: 43
Default 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