Macro to copy and past a new row when the a row is filled in.
if your in a blank cell and you want to copy the first row above that that
contains data:
Sub AddRow()
if len(trim(ActiveCell)) = 0 then
ActiveCell.End(xlup).EntireRow.copy
ActiveCell.EntireRow.Insert Shift:=xlDown
End if
End Sub
--
Regards,
Tom Ogilvy
"lookLikeWorks" wrote:
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
|