View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helge V. Larsen Helge V. Larsen is offline
external usenet poster
 
Posts: 7
Default From which cell is my VBA function called ?

I have a VBA function that is called from many cells in several worksheets
in my workbook. The function performs some error trapping (data checking)
and gives a message if an error is found.

However, I need to retrieve information on from where the erroneous call of
the function is placed (sheet and cell).

Is it possible to get this information by VBA ?