Hi JMB, bgeier and mudraker,

A heads up of what I am trying to do (in case you are getting horribly
confused)...
Each sheet has a matrix of 8 columns and normally 40 rows (these are
made up of ones or zeros). I need the macro to compile (on the compiler
sheet) a matrix that is made up of parts of various matrices from the
other sheets; P3,P4 of each sheet will dictate which cells to copy, p5
will dictate which is the next matrix (sheet) to go to.
(95% of the marco now works - thanks a million for that:)
Just one narly issue remains...
the compiler sheet does not make a matrix....
The rule is - If a cell or range of cells are copied they need to
(ultimately) be pasted onto the compiler matrix in same postion that
they came from on the sheet of origin.



JMB
The changes you suggested work well, now be either specifying the full
range and partial or full range in P3, P4 respectively it seems to copy
properly!!!!!
As for the pasting by transposing i,j it now copies to rows however I
notice that it does not copy a single row of 8 cells then copying the
next 8 underneath it, rather it will copy the first range specified in
P3 into on long row then do the same for P4. (similar result with i,j
other way around too)

Would it be easier to get the macro to first paste all cells (as
selected in p3, p4 of each sheet) into 1 column on the compiler sheet
THEN break the column down into 40 rows (one data frame) of 8 cells
(bits). I need to reproduce the orignal form of the data packet (8
columns and normally about 40 rows)
If so how do I do that??

No stress if its too hard


Hi bgeier,

I tried filling in the sheets with values to overcome this problem
however the same error still occurs

Thank you both for all your work

Simon


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