Type Mismatch Error

[D Van]

I am receiving a type mismatch error on the below. I am using the RangeCat
function that I was provided earlier last week.

Dim RangeCat as Variant

Range("Sheet2!A1").Value =
Application.WorksheetFunction(RangeCat("Macro!A2:A500", ",", 1))

Any ideas?

Thanks

 

[Juan Sanchez]

D Van

It doesn't seems completely right, you are calling
function RangeCat , which I belive is a UDF, with the
application.worksheetfunction but this method works only
for built-in functions. On top of that you seem to be
declaring it as a variable (Dim RangeCat)...

Maybe if you post the entire code and what it is supposed
to do someone can give better advise...

Cheers
Juan