Excel Trim , Clean or IsNonText function doesn't work

[munzer1]

I was able to make Excel ROWS and COLUMN function to work in VB but Trim, Clean, or ISNONTEXT just won't work. I have tried all possible combinatin of syntaxt and was able to compile in VBE but no luck.

MyName1 = Cells(4,5)
MyName2 = ([=Trim(MyName)]) ----it give error code 2029 right here.

Does this have anything to do with Tools->Reference environt variables or something?
Interestingly, trim and clean function works just fine in Excel table itself.

Trim macro gave me the following:

Please Login or Register  to view this content.

I have installed all the adds-in but still it did not work.

some of the adds-in is asking for password. Any idea why?

[mudraker]

munzer1

Please wrap your VBa code - see red link below for instructions

Please read forum rules - see blue link below

[royUK]

Do you mean

Please Login or Register  to view this content.

[munzer1]

Do you mean

Please Login or Register  to view this content.

Above syntax did not work.