Are you going to be selecting this region? or is it like Column A?
can help you write the code, just need more info...

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

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48235