View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam Adam is offline
external usenet poster
 
Posts: 287
Default 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?