Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Blank Cell in case of false If | Excel Worksheet Functions | |||
How to fill a blank cell down to a filled cell | Excel Worksheet Functions | |||
Fill cell that is blank | Excel Worksheet Functions | |||
fill blank cell with cell above: special case | Excel Programming | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) |