Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a function from VBA
I have some functions in VBA e.g. one that is called
Function CountByColor(InRange As Range, WhatColorIndex As Integer, Optional OfText As Boolean = False) As Long. When i write =CountByColor(A2:A4;3;FALSE) in my worksheet it returns #NAME?. What am I doing wrong? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a function from VBA
problem solved, pls disregard
"Adam" skrev: I have some functions in VBA e.g. one that is called Function CountByColor(InRange As Range, WhatColorIndex As Integer, Optional OfText As Boolean = False) As Long. When i write =CountByColor(A2:A4;3;FALSE) in my worksheet it returns #NAME?. What am I doing wrong? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a function from VBA
Adam,
Two things spring to mind. Have you stored the code in a general code module (not a form, sheet module or ThisWorkbook)? Also, but I don't think this is the problem, you are using continental separators (; not ,). Is this correct for your Excel? -- HTH RP (remove nothere from the email address if mailing direct) "Adam" wrote in message ... I have some functions in VBA e.g. one that is called Function CountByColor(InRange As Range, WhatColorIndex As Integer, Optional OfText As Boolean = False) As Long. When i write =CountByColor(A2:A4;3;FALSE) in my worksheet it returns #NAME?. What am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a do not call function? | Excel Discussion (Misc queries) | |||
how i can call the function | Excel Worksheet Functions | |||
how to call a function with variance which is function Name | Excel Programming | |||
Function Call | Excel Programming | |||
call function | Excel Programming |