Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi gang.
I am stuck on asomething that has become quite curly. Yet it seems like it should be 'obvious'. I The VBA code itself: "Highlight( )" works great. Except in the specific context I _want_. This is what I want to do. I have a user function that takes a cell reference (As Range). I want to change the display attributes of the range given. For simplicity conside the simple example below. The Sub works and the Function does not work. Can someone point me to a place that explains what I need to do so I can use the Range from within the Function. My debugging message boxes all reprot that "thisRange" is a range, and good to go. Except that it doesn't "work" via the function. Thanks in advance, Will. ==========================[ example ]============ Function setHighlight( thisRange As Range ) Call Highlight( thisRange ) End Function '----------------- Sub macroHighlight( thisRange As Range ) Call Highlight( thisRange ) End Sub '----------------- |
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 |