Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
why would code such as this cause an error?
sub test() dim maturitydate as date maturitydate=cells(1,1) end sub cells(1,1), in this particular case, is empty, or so it seems. the spreadsheet formula in cells(1,1) is: ="" when cells(1,1) is 6/30/06 it runs fine. when formula has ="" i expect code to return 'empty', but it stops for some reason. thx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |