Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error: Type mismatch
i have a vba code included the following:
shortest = count(1) For r = 1 To 200 If count(r) < shortest And count(r) 0 Then shortest = count(r) End If Next Rows("shortest:shortest").Select Selection.Cut Rows("1:1").Select Selection.Insert Shift:=xlDown However, when i try to run the code, the debugger promt an error message said : type mismatch and then highlight the code: Rows("shortest:shortest").select. I declared "shortest" as variant. Can any pro point out my mistake?Thank you very much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |