Thank you for the info. That just made life a bit simpler in the project.
*** John


"K Dales" wrote:

Yes, VBA is VBA whether in Access or Excel. Only thing different is the
object model. So the On Error ... statements and the Err object are
applicable in both settings.
--
- K Dales


"JohnE" wrote:

Hello. Generally I work in Access but have been asked to work on automating
a series of spreadsheets in a workbook. For the most part I have the coding
but what I was wondering about more is the error trapping. Is it the same as
what I would use in MS Access?
Thanks to anyone who responds.
*** John