I'd like to create an array to place values in column A into Column B
and remove blank cell from column A.

Example:data in column "A" has blank cell at A2, I'd like to have
column "B" show the values and elimate the blank cell.

A............B
4............4
blank.......5
5............6
6

Your assistance is appreciated.

Travelersway


--
travelersway
------------------------------------------------------------------------
travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=518077