formula for inserting rows
"Bob Phillips" wrote:
Have you inserted it in a worksheet code module as instructed?
--
HTH
Bob Phillips
"Carol49" wrote in message
...
"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
|