How to get address of cell which calls a VBA Functions in a Excel sheet

by

You can use Application.Caller, but you would probably be best to pass the cell to the function.

   With Application.Caller
        CallerRows = .Rows.Count
        CallerCols = .Columns.Count
        CallerAddr = .Address
   End With

See: http://www.cpearson.com/excel/WritingFunctionsInVBA.aspx

To pass the cell:

 =SomeFunction(A1)

Where the code has:

SomeFunction(r)

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Excel VBA deleting rows in a for loop misses rows
  4. What is the lifetime of a global variable in excel vba?
  5. Download attachment from Outlook and Open in Excel
  6. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  7. Embed picture in outlook mail body excel vba
  8. How to check for empty array in vba macro [duplicate]
  9. Use autofilter on more than 2 criteria
  10. What is the function of FormulaR1C1?
  11. Compiler Error: User-defined types not defined
  12. Open a workbook using FileDialog and manipulate it in Excel VBA
  13. Vba Excel do vlookup from a closed file
  14. excel hyperlink to nothing
  15. How to add headers to a multicolumn listbox in an Excel userform using VBA
  16. How to send files via HTTP_POST with Excel using VBA?
  17. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  18. How to Add Date Picker To VBA UserForm
  19. Vba macro to copy row from table if value in table meets condition
  20. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  21. Set a cell value from a function
  22. simple vba code gives me run time error 91 object variable or with block not set
  23. VBA Function argument list select
  24. Calling regasm without administrative rights for COM interop in Excel VBA
  25. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  26. How do I activate a specific workbook and a specific sheet?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment