On error resume next
'your line of code that may cause the error
if err.number < then
err.clear
msgbox "some error just took place!"
end if
on error goto 0



On 08/29/2010 18:41, Fan924 wrote:
I am getting runtime error 1004 when I run a macro and.... the
imported file is to big. The error is expected.

My question, can I replace this error message with something else?
Something instructive?

--
Dave Peterson