Quote Originally Posted by mvidas
Amanda,

For xld's answer (btw - xld = Bob), you would probably only have to change the ' = "" ' portion to ' <> "" ' to get it to work. Rich's last one wouldn't work if there were two non-blanks in a row. I'm not sure if Zack's suggestion would work for formulas (I didn't test it :P).
Matt
Interesting, Matt. It would have to be run again for however many non-blank cells were contiguous. But it does work.