question

BradMcIntyre-8213 avatar image
0 Votes"
BradMcIntyre-8213 asked BradMcIntyre-8213 answered

Excel Custom Function - What cell is being Calculated

Thank you for taking the time to read my question

I have a custom function that I've created. I'm wondering if it's possible to tell what cell is being calculated by the function.

Thanks!

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BradMcIntyre-8213 avatar image
0 Votes"
BradMcIntyre-8213 answered

Hi,

This is what I was able to find.

With Application.Caller
myFunc = .Row & "--" & .Column
End With

Put this in the UDF and you'll know what cell is currently being worked on.

Thanks,
Brad

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft edited

Hi @BradMcIntyre-8213,
You can use Find option in Excel to help you, please follow these steps:

Press Ctrl + F- select Options > >- Look in: Formulas- enter the custom function name you need to find:
82089-166.gif

Hope it's helpful.
If the response is helpful, please click
"Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.*





166.gif (229.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.