Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have that code
public function toto(r as Range) as long dim i as long for i = 1 to r.count toto = toto + r.Cells(1,i).value if r.Cells(1,i).value < 10 then r.Cells(1,i).select with selection.font .Strikethrough = True End With end if next i end function if I'm in the execution window i can type ?toto(activesheet.range("A1:A12")) that works fine but if in a cell I type =toto("A1:A12") the fonction does sum the values but the select and the strikethrough does'nt work. thanks Cédric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If function and a range | Excel Worksheet Functions | |||
Range of a function | Excel Discussion (Misc queries) | |||
DBSUM function but with function as criterion, not a range | Excel Worksheet Functions | |||
range function | Excel Discussion (Misc queries) | |||
Between/ range function | Excel Discussion (Misc queries) |