Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Chip
I was afraid it is something like ... c you should remember than VBA code, whether called directly or indirectly c from a worksheet cell, cannot change anything. It can only return a value. The setHighlight() returns a nice string saying "done". The required effect is to _change_ the reference. Is there some way to affect changes from inside a function? Say launch another macro or something? Thanks for pointing me out of a dead-end. Cheers, Will. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
Have end user add missing references without accessing the vba pro | Excel Programming | |||
How to create a function using references | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |