Change
dblRes = Tan(1#)
to
dblRes = Tan

But as Bob mentioned, Tan is a reserved word in VBA (it means the
trigonometric function Tangent), so you should change the name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



<Andrew.Kirkham@gmail.com> wrote in message
news:1150817701.996466.253920@u72g2000cwu.googlegroups.com...
> Hi,
>
> In Excel XP the following code generates the error:
> Compile Error - Expected Array
>
> Enum ColourID
> Rose = 38
> Lavender = 39
> Tan = 40
> LightBlue = 41
> End Enum
>
> Sub Test()
> Dim dblRes As Double
> dblRes = Tan(1#)
> MsgBox dblRes
> End Sub
>
>
> If I remove the Tan colour ID from the enum it works as
> expected.
> Presumably Excel is seeing Tan in sub Test and matching it to
> ColourID.Tan and not the Tan function.
>
> So how do I get Excel to use the Tan function in this case?
>
> [Interestingly, you cannot put a lower case 't' on tan in the
> enum -
> VBA changes it to 'Tan']
>