bob dot phillips at tiscali dot co dot uk

do the obvious with it

--
HTH

Bob Phillips

"Carol49" <Carol49@discussions.microsoft.com> wrote in message
news:45A2331C-FC86-4573-A66C-BC5D0B762EA7@microsoft.com...
>
>
> "Bob Phillips" wrote:
>
> > Can you ,ail me your workbook?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Carol49" <Carol49@discussions.microsoft.com> wrote in message
> > news:0A9E7AE4-FDAC-4DC7-8F91-881CFC1E4057@microsoft.com...
> > >
> > >
> > > "Bob Phillips" wrote:
> > >
> > > > I am confused, it is fine here.
> > > >
> > > > You say you pasted the formula. What exactly have you copied in?
> > > >
> > > > --
> > > > HTH
> > > >
> > > > Bob Phillips
> > > >
> > > > "Carol49" <Carol49@discussions.microsoft.com> wrote in message
> > > > news:8047BFB0-6258-4043-9408-B48E06E1032C@microsoft.com...
> > > > >
> > > > >
> > > > > "Bob Phillips" wrote:
> > > > >
> > > > > > Have you inserted it in a worksheet code module as instructed?
> > > > > >
> > > > > > --
> > > > > > HTH
> > > > > >
> > > > > > Bob Phillips
> > > > > >
> > > > > > "Carol49" <Carol49@discussions.microsoft.com> wrote in message
> > > > > > news:89553CF1-520E-4EBF-A4A3-8EF4A8C1C0C1@microsoft.com...
> > > > > > >
> > > > > > >
> > > > > > > "Carol49" wrote:
> > > > > > >
> > > > > > > > Need formula that will allow a number e.g. 5 to be placed in
a
> > cell,
> > > > > > which
> > > > > > > > t\will then insert 5 rows. Thanks
> > > > > > > Formula is what I am looking for, but I am getting a syntax
error
> > in
> > > > the
> > > > > > line
> > > > > > > If Not Intersect(Target, Me.Range("A1:A10")) Is Nothing Then
> > > > > > > I have copied and pasted, should I be doing something else?
> > Thanks
> > > > > >
> > > > > >
> > > > > > Yes, I am right clicking on sheet tab and clicking on View Code
and
> > then
> > > > pasting in formula. Thgat line always comes up red and when I go to
> > enter
> > > > in the appropriate cells on the correct sheet I gfet the Compile
Error -
> > > > Syntax Error. Thanks
> > > >
> > > >
> > > > I have tried from Private Worksheet.....
> > > also from On Error Go....
> > > and I stop after End Sub
> > > Thanks
> >
> >
> > Yes, I can. Where do I email it to?