View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trent Argante[_2_] Trent Argante[_2_] is offline
external usenet poster
 
Posts: 15
Default Using User-Defined Functions in Cells

Because you guys told me that Excel doesn't support changing other cells
& manipulating the environment through in-cell formulae, I quit pursuing
that route and solved it through detecting the change via the 'Change'
event, testing the 'Target' parameter and calling my 'PPAPNumber'
function. And, it works!

Thank you guys very much! I was banging my head against the wall.
Aaah, relief; 'tis so sweet.

Trent Argante
[DC.J(510)]

*** Sent via Developersdex http://www.developersdex.com ***