fill blank cell with cell above: special case
 

Dear all,

I have a column filled text "Break" and "1___#1"
Then, I have to fill blank cell with cell above for text "Break" only.
And running will stop at text "1___#1"
But, If there is no "1___#1" under "Break", there is no fill blank cell
activity.

Example:
A
1|Break
2|
3|1___#1
4|
5|Break
6|
7|Break
8|1___#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,
Mut


--
Mut
------------------------------------------------------------------------
Mut's Profile: http://www.excelforum.com/member.php...o&userid=30633
View this thread: http://www.excelforum.com/showthread...hreadid=568849