![]() |
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 *** |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com