TRIM, ISTEXT function won't work in Excel VBA code
Envirnment: Using Windows 2003 and Office 2007 upto date with all service packs.
Problem: Even after installing all Excel Adds-in bunch of Excel functions ( Text and Information functions) doesn't work from within the VBA code but they work fine in the Excel sheet itself.
I was able to make Excel ROWS and COLUMN function to work in VBA but Trim, Clean, or ISNONTEXT just won't work. I have tried all possible combinations of syntax and was able to compile in VBE but no luck.
MyName1 = Cells(4,5)
MyName2 = ([=Trim(MyName)]) ----it give runt time error code 2029
MaxNumberOfMyTable = [=MAX(PatientTable[PID]]
Above MAX function did not work either. PID is the column name.
But this works fine:
LastRow = [=Rows(PatientTable[PatientName])]
Why the adds-in is asking for password when tried to open them in the in the project browser window? How/where to get the passwords from?
|
