Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application or object error - one last try
I've posted about this error before, but no one can seem to figure it out.
I'm validating the input in a spreadsheet that is created by VBA. The validation criteria works just fine when I enter it into the custom validation box: =AND(LEN(B7)=7,ISNUMBER(MID(B7,2,6)*1),CODE(LEFT(U PPER(B7),1))64,CODE(LEFT(UPPER(B7),1))<91) When I put that same forumla into VBA, as validation criteria, it looks like: ..Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=AND(LEN(B7)=7,ISNUMBER(MID(B7,2,6)*1) ,CODE(LEFT(UPPER(B7),1))64,CODE(LEFT(UPPER(B7),1) )<91)" This line gives a Application defined or object defined error. I've run the first term (LEN(B7)=7 separately, and it runs fine. But the second term, ISNUMBER(MID(B7,2,6)*1) ,CODE(LEFT(UPPER(B7),1))64,CODE(LEFT(UPPER(B7),1) )<91) doesn't run. So does anyone see what is causing the problem? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error '1004' application or object defined error | Excel Programming | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |