Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think you should add an exit sub in the code below. You are going to get
an error if you don't make the change. from Title:="Please select a file") If Fname = False Then ' They pressed Cancel MsgBox "Stopping because you did not select a file" End If to Title:="Please select a file") If Fname = False Then ' They pressed Cancel MsgBox "Stopping because you did not select a file" exit sub End If "Utahstew" wrote: Thank you Joel, your fast response is appreciated I had forgotten arrays start at 0. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Large Data File Consolidation... | Excel Worksheet Functions | |||
Very large file - simple data | Excel Discussion (Misc queries) | |||
Importing (too) large data file | Excel Discussion (Misc queries) | |||
Using condition to extract data by matching values from 2 different Excel files | Excel Programming | |||
Extract only non-matching data | Excel Programming |