philfer
10-30-2008, 06:50 AM
Hello,
I am trying to write a custom function that I intend to distribute as an add-in.
However I need to know whether the user clicked on one cell or ten cells before I can get the function to process them. How do I get the function to detect this. Do I pass the target range as a parameter to the function. How can I then process each individual cell.
I hope I am making some sense!
Thanks for your help in advance
Phil
I am trying to write a custom function that I intend to distribute as an add-in.
However I need to know whether the user clicked on one cell or ten cells before I can get the function to process them. How do I get the function to detect this. Do I pass the target range as a parameter to the function. How can I then process each individual cell.
I hope I am making some sense!
Thanks for your help in advance
Phil