Syntax Error 1004

Hi,

I am trying to create a macro with VBA using the following formula:

=IF(ISNUMBER(SEARCH("coles",F2)),"Groceries",IF(ISNUMBER(SEARCH("woolworths",F2)),"Groceries",IF(ISNUMBER(SEARCH("pharmacy",F2)),"Pharmacy",IF(ISNUMBER(SEARCH("bupa",F2)),"Health Insurance",IF(ISNUMBER(SEARCH("tcs",F2)),"Hair",IF(ISNUMBER(SEARCH("medical",F2)),"Medical",IF(ISNUMBER(SEARCH("interest",F2)),"Interest",IF(ISNUMBER(SEARCH("xero",F2)),"Accounting",IF(ISNUMBER(SEARCH("top up",F2)),"CC Exp",IF(ISNUMBER(SEARCH("thomas",F2)),"Income",IF(ISNUMBER(SEARCH("telstra",F2)),"Phone",IF(ISNUMBER(SEARCH("ep loan",F2)),"EP Exp",IF(ISNUMBER(SEARCH("Tville loan",F2)),"Tville Exp",IF(ISNUMBER(SEARCH("ergon",F2)),"Power",IF(ISNUMBER(SEARCH("unit  51",F2)),"Tville Inc",IF(ISNUMBER(SEARCH("car",F2)),"Car Exp",IF(ISNUMBER(SEARCH("townsville city",F2)),"Tville Exp",IF(ISNUMBER(SEARCH("LSC",F2)),"EP Exp",""))))))))))))))))))

When I try to run the macro it comes up with a syntax error 1004.

If I reduce the formula to

=IF(ISNUMBER(SEARCH("coles",F2)),"Groceries",IF(ISNUMBER(SEARCH("woolworths",F2)),"Groceries",IF(ISNUMBER(SEARCH("pharmacy",F2)),"Pharmacy",IF(ISNUMBER(SEARCH("bupa",F2)),"Health Insurance",IF(ISNUMBER(SEARCH("tcs",F2)),"Hair",IF(ISNUMBER(SEARCH("medical",F2)),"Medical",""))))))

it works fine.

It is as though VBA can only handle up to a certain formula length.

Could anyone help?

Cheers
T