Highlight a row with a "1" in it, then Right-click Copy then move to
highlight the row just below where you want a new row inserted, and do
Right-click InsertCopiedCells

Vaya con Dios,
chuck, CABGx3


"Caveman" wrote in
message ...

If i highlight column D and insert 1 so that it shows in every row, if i
insert a new row that cell in column D is blank. How can i insert a new
row and get the 1 to show automatically so the whole column is still
full of 1 in every row.


--
Caveman
------------------------------------------------------------------------
Caveman's Profile:
http://www.excelforum.com/member.php...o&userid=27546
View this thread: http://www.excelforum.com/showthread...hreadid=472293