My excel sheet has some formatting/formulas that is wish to copied and pasted
as i reach the end of my sheet. Currently I hit ctrl "a" when on a blank on
to add another. But, would like it to automatically run the macro when the
line above the blank on has a cell 0 or NOT €œ €� so there will always be a
blank row below where i am typing. The macro I am using is:

Sub AddRow()
'
' AddRow Macro
' Macro recorded 12/14/2006 by PorterJ
'
' Keyboard Shortcut: Ctrl+a
'

ActiveCell.Rows("1:1").EntireRow.Select
Selection.Copy
Selection.Insert Shift:=xlDown
End Sub

'

thanks for any help you can provide...

Porter