Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why do I get the error? Oddly enough, I can use the commented line for the
debug.print, but when I try to assign to an array it gives the error. I'm totally confused. Bob Dim FName as Variant Set fs = Workbooks.Application.FileSearch With fs .LookIn = "E:\Stott\Inventory" '.FileType = msoFileTypeExcelWorkbooks .FileName = "Input??.xls" .Execute End With For i = 1 To fs.FoundFiles.Count FName(i) = fs.FoundFiles(i) 'Debug.Print fs.FoundFiles(i) Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |