In VBA, for all blank cells in one column of the current region of the
active sheet, I want to add a formula that will put in the value of the
cell immediately above the blank cell. The current region is different
for each sheet in the workbook. Any ideas? Thanks.


--
jerrystan
------------------------------------------------------------------------
jerrystan's Profile: http://www.excelforum.com/member.php...o&userid=28573
View this thread: http://www.excelforum.com/showthread...hreadid=482355