Again it is a version thing. This thread says it is from XL2000 onwards:

http://tinyurl.com/2cebvt

and this thread suggests that that there is a difference again in XL2003

http://tinyurl.com/2eexem

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Tyro" wrote in message
. net...
Sandy:

There is still one more little problem with the code. If the row 2 rows
above the row containing the word "Balance" in column D is deleted, the
row above the row with the word "Balance" becomes the active row and the
code is activated because of the deletion. The code sees the word
"Balance" in the row below and inserts a row.

Tyro

"Sandy Mann" wrote in message
...
First of all my apologies for not including the lines to turn off and on
Events but the code only fires once - I tried printing to the immediate
window in the *If* statement and it only prints once - I'm using XL97,
perhapd it's a version thing.

To reset the page breaks at every entry would slow things down and that
is why I suggested setting them only prior to printing. Referencing
PrageBreaks seems to be very complicated as this thread and example from
Tom Ogilvy shows:

http://tinyurl.com/2vtxs9

You may be better posting your request in the programming group

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"robert morris" wrote in message
...
Tyro,

Beauuuutifull !! That does the job just as I wanted it. As to the
"balance" paid to Rulon, should have been Invoice, Deposit, "Allocated
to";
the word "balance" was just a typo. As to the dollar amounts, all that
really counts is the "contract amount in Col E, pymts in Col F and
Balance in
Col G.

I will continue to work with it and your second VBA.

You people are so helpful and as we say in the deep south, "how you know
all
that stuff?" Last word cleaned up for publication on this format.

Now, if we could only "auto" page break!!

Again many thanks,

Bob M.

"Tyro" wrote:

For consistency's sake you might want to put a blank row before every
row
that has the word "Balance" in column D. Also "Balance Remaining" that
the
code checks for is not consistent. I noticed a "Balance to Rulon -
$32-153"
in column D.
If you want the code to insert a new row when column D begins with
"Balance
" you could again change the code to

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Columns("D:D")) Is Nothing Then Exit Sub
If Left(Cells(Target.Row + 1, "D").Value, 8) = "Balance " Then
Application.EnableEvents = False
Cells(Target.Row + 1, "D").EntireRow.Insert
Application.EnableEvents = True
End If
End Sub

Tyro



"robert morris" wrote in
message
...
Sandy,

I must have done something wrong. I copied your code into VBA module
but,
when I enter text in the row above "Balance Remaining", Col D, then
tab to
enter deposit paid, Col e, it enters 89 additional rows. What did I
miss?

Thanks,

Bob M.



"Sandy Mann" wrote:

"Tyro" wrote in message
...
He can do that by manually inserting a row

The OP asked:

Two questions; One - is there a way to auto insert additional
rows

"Tyro" wrote in message
...
blank row above "Balance Remaining" but his example did not show a
blank
row between the last row with data and "Balance Remaining".

On the contrary, apart form Rows 14 & 97 every, what the OP called
"bordered" areas, has at least one blank row above the "Running
Balance"

Only Bob can tell us what he wants - if you haven't put him off by
telling
him that *There is no "auto" way*

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk