editing a dynamic array

[RobcPettit]

Hi Im using a dynamic array to take data from one workbook and to then
paste to another workbook. Its 6 collomns by 900 rows. What I need to
do is paste this data across 8 workbooks, removing the the last 100
rows each time, eg, wb1 900, wb2 800, wbk3 700, etc. Is there a way of
resing my array each time removing 100 rows, if not then pasting only a
certain number of rows from my array. I know I could just sellect the
required number of cells in the original wb each time but an array is
so much faster
Regards Robert

 

[jindon]

Hi,

I don't know how you are outputting array data to each sheet, but I
don't think
you need to change the size of the array data.
You only need to change the size of outputting area.

e.g

Workbooks(wb1).Sheets(1).Range("a1").Resize(Ubound(Myarray,1)-100,Ubound(Myarray,2)).Value=Myarray

 

[RobcPettit]

Thanks Jindon, this is perfect, and a lot easier than I thought it was
going to be.
Regards Robert