Excel does quirky things sometimes.......

Try opening a new workbook and copying your data to it without the
merged cells, type in your first two lines and try again.

It's the equivalent of thumping the TV to bring the picture back lol.

TGHC


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=494715