Since you code shows you are writing a formula to a cell, then you shouldn't
be limited beyond the limitations you would find in entering the formula by
hand.

Sumproduct will work with worksheet functions Trim, Left, Upper, but is has
to be in the resulting formula, not in VBA.

If you want to get the best advice on writing sumproduct formulas, ask in
Microsoft.public.excel.worksheet.functions

--
Regards,
Tom Ogilvy

"vbastarter" wrote in message
...
Hi I have code using sumproduct to copy paste duplicate names into another
sheet.
I have used sumproduct so that the process is quick. But I can't do
things
like TRim. Ucase or even compare duplicates just with first letter in
firstname col. Anyone knows if this can be achieved while using sumproduct
?
Or if theres an alternative method that is as effecient time as
sumproduct
Thanks in Advance