USer defined functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Run time Error - Application Defined or Object Defined Error Excel Vba 0
VBA Insert Into Specific Cell 0
show cell reference as text 5
Hide columns according to background fill color 2
User Defined Function being called by changes to an independent workbook 13
Setting A Default Value 2
Just out of curiousity, why didn't this work (a change perpetuated to all sheets)? 1

Back
Top