Not sure if this will help but I had a similar situation a while back (when I
ran my macro it could not find the end of the previous data and thus I copied
over existing data.) A fellow responded to my problem with this reply (and
it worked for me)

'Tim,

Every place where you have

Selection.End(xlDown).Select
Range("?28").Select

Change it to

Selection.End(xlDown)(2).Select


"simonsmith" wrote:


Hi,
Can anybody help me with this little beauty? I am a first time loop guy
so not sure what to do here... I have a table of data 8 columns wide and
normally 40 rows high. I want to copy rows A1 to H1 and
transpose them into a single column (e.g. column N)then take the values
in A2 to H2 and transpose them into the same column underneath the
previously transposed column (N). What I am trying to achieve is to
take this table of data and turn it into a single serial string. Also
when the macro loop first starts it needs to check the column it is
transposing to (e.g. N) does not already have data in it, if it does
then it needs to transpose to an adjacent column.

Narly...yes?? Any help very much appreciated


Cheers

Simon


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=539963