Re: Cannot trace this simple error
From: Stuart (sg_booth_at_hotmail.com)
Date: 03/31/04
- Next message: Bret: "Custom Menu Bars Not Saving"
- Previous message: Charles: "Re: Finding Column based on input, then first empty row"
- In reply to: Stuart: "Re: Cannot trace this simple error"
- Next in thread: Paul Robinson: "Re: Cannot trace this simple error"
- Reply: Paul Robinson: "Re: Cannot trace this simple error"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 20:39:18 +0100
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
- Next message: Bret: "Custom Menu Bars Not Saving"
- Previous message: Charles: "Re: Finding Column based on input, then first empty row"
- In reply to: Stuart: "Re: Cannot trace this simple error"
- Next in thread: Paul Robinson: "Re: Cannot trace this simple error"
- Reply: Paul Robinson: "Re: Cannot trace this simple error"
- Messages sorted by: [ date ] [ thread ]