I have a column of data in a worksheet (50 rows A1:A50). At the moment
the data is hard coded i.e. A1=sheet2!ab1,B1=sheet2!ab2, etc.

Sometimes there is no data in source cells (e.g. ab15 ,ab19 etc), whic
results in many blank rows in the destination worksheet. At the momen
I am hiding the blank rows with code, which now creates a problem fo
me in extracting data into a Word doc.

Is there a way to populate the destination worksheet sheet such tha
the rows remain contiguous without any blank rows (i.e. no blank o
hidden rows?).

Any help much appreciated, please bear in mind I'm new to VBA!

Cheers,

Pete

--
peter.thompso
-----------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...fo&userid=2968
View this thread: http://www.excelforum.com/showthread.php?threadid=50084