after u declare variables use
on error goto abc
and before end sub
abc:
exit sub
use error handlers
http://www.xlpert.com/partG.htm
http://www.functionx.com/vbaexcel/Lesson26.htm
On Thu, Auon errg 11, 2011 at 1:16 PM, Andy McGooner <
andrew_mcni...@yahoo.co.uk> wrote:
> Hi All,
>
> I hav
Hi All,
I have a spreadsheet that stores data from a text file, the idea being
that it opens the file dialog and i select the relevant text file. The
problem is that when i do the file open and press cancel i get the
folowing message:
Run-time error '1004'
false.xls could not be found
How do i