fill blank cell with cell above: special case
 

Dear all,

I have a column filled text "Break" and "____#1"
Then, I have to fill blank cell with cell above for text "Break" only.
Because filling could be stop at text "____#1"
But, If there is no "____#1" under "Break", there is no fill blank cel
activity.

Example:
A
1|Break
2|
3|____#1
4|
5|Break
6|
7|Break
8|____#1


Could be...
A
1|Break
2|Break
3|Break
4|
5|Break
6|
7|Break
8|Break

Can somebody send me VBA code or formula..
Any help would be appreciated.
Thanks.

Regards,
Mu

--
Mu
-----------------------------------------------------------------------
Mut's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=55085