Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ByRef strangeness
Hello,
I have a formula foo which is used in a worksheet as =foo(A1:A10) and it is defined in a module as Public Function foo(ByRef data As Range) As Double There I would like to do some visual formatting on the data such as data.select data.font.colorindex = 3 But there is no reaction. Is there something I have misunderstood about passing variables to custom functions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
byref errors | Excel Programming | |||
More HpageBreaks Strangeness | Excel Programming | |||
ByRef question | Excel Programming | |||
ByRef not passing address | Excel Programming | |||
Is ByVal always better if ByRef isn't necessary | Excel Programming |