Re: Cannot trace this simple error

From: Paul Robinson (paul.robinson_at_it-tallaght.ie)
Date: 04/01/04 

Date: 1 Apr 2004 00:00:58 -0800

Hi Stuart
Sounds like your problem has more to do with your looping through
workbooks then. Can you show us that code? It may be that a sprinkling
of "Do Events" might fix your problem.
regards
Paul

"Stuart" <sg_booth@hotmail.com> wrote in message news:<ujXKff1FEHA.3064@tk2msftngp13.phx.gbl>...
> Right, I've run the code on each book from that original folder.
> By that, I mean by copying each book into an empty folder
> and running the code in turn.
> Each book ran well past that original problem, including
> therefore the problem book.
>
> Problem is that this routine is designed to calculate Value
> Added Tax (three different rates, sometimes more), so I
> guess Customs & Excise would be pleased if I got it right
> first time, rather than after they call on me!
>
> Regards.
>
> "Stuart" <sg_booth@hotmail.com> wrote in message
> news:%23xxKAS1FEHA.1012@TK2MSFTNGP11.phx.gbl...
> > Thanks but no sheets appear to be hidden. I've copied that book
> > to a new folder and run the code on it alone, with no problem. So...
> >
> > Will post back if I can't isolate the problem.
> >
> > Regards.
> >
> >
> >
> >
> > I'm going to copy it into a new folder and
> > "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> > news:uTfiE$0FEHA.2472@TK2MSFTNGP10.phx.gbl...
> > > Any chance it could be referencing a hidden *** in that file that may
> have
> > > protection on it, and not the *** you are looking at?
> > >
> > > --
> > > Regards
> > > Ken....................... Microsoft MVP - Excel
> > > Sys Spec - Win XP Pro / XL 97/00/02/03
> > >
> >
> > --------------------------------------------------------------------------
> > --
> > > It's easier to beg forgiveness than ask permission :-)
> >
> > --------------------------------------------------------------------------
> > --
> > >
> > > <snip>
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004
> > >
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.644 / Virus Database: 412 - Release Date: 26/03/2004
> >
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.644 / Virus Database: 412 - Release Date: 26/03/2004