When using a Debit card enter a letter instead of the date into the reconciled column. Select the row above where you want to insert the rows, this is also the row whose formulas will be copied down. Private Sub Worksheet_Before Double Click(By Val Target As Range, Cancel As Boolean) Dim lastrow As Long 'D.
[offset], [insrtrow] [dclick], [copyformulas], [Insert Blank Rows], [moreresize], [Change Event], [extended], [Alt Blanks], [Col Achg], [before_a], [reconcile], [Manual Insert], [Delete K], [Delete R], [addendum], [sign_onright], [fixrightminus], [clear Cols], [extra Totals], [blankrows], [multilabel], [#VALUE!
], [carrybalance], [related], This page also contains Worksheet EVENT macros, which are installed differently.
My DR/CR are the opposite of what most US checkbooks show, since I prefer to keep records for myself and not for my bank or their point of view. Resize( _ rowsize:=v Rows 1), xl Fill Default On Error Resume Next 'to handle no constants in range -- John Mc Kee 2000/02/01 ' to remove the non-formulas -- 1998/03/11 Bill Manville Selection. The main article on this page, Insert Rows And Fill Formulas Macro, is above, the rest of the material deals with specialized implementations of the above or specialized macros that provide similar function.
At one time you could ask the bank to provide with with a properly labelled checkbook, but now you would probably have toe chenage the titles yourself. The following macro will clear the constants from selection area(s).
The primary macro Insert Rows And Fill Formulas is installed on a toolbar button.