It should return all columns but if A&B are merged on one row the 2nd
field will be the value NULL and it only that row that will have this
charastic.

The code as you supplied run with a print to the immediate window.
a3 b3 c3
a2 Null c2
a1 b1 c1

Also do set the object to Nothing as well as closing them and it would
be safer to use option explicit and declare the variables properly.

I presume the code is not operating on data within it's own spreadsheet
- this tends to have fewer problems.

Well done.

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=510907