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