select variables ranges, copy to array, paste the array in new workbook

[Mathew]

Hello,

I've got an excel file with differents range of data, all separated by a
blank line.
I need to create a new workbook for each of those range (which are a
variable number a lines).

I'm trying to do it create a temporary array, fill it with the line, to copy
it after on a new worksheet.

But it doesn't work... !!!

CAn someone help me ?

Mathew

[Jan De Messemaeker]

Hi,

Would you please decide what your problem is, and in which newsgroup you
want to post?
I cannot imagine a problem that would be interesting for BOTH Word and
Project specialists.
Thanks ahead.
Merci d'eavance.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
" Mathew" <matthieu_in_hk@hotmail.com> schreef in bericht
news:#5IaAEpNFHA.1948@TK2MSFTNGP14.phx.gbl...
> Hello,
>
> I've got an excel file with differents range of data, all separated by a
> blank line.
> I need to create a new workbook for each of those range (which are a
> variable number a lines).
>
> I'm trying to do it create a temporary array, fill it with the line, to
copy
> it after on a new worksheet.
>
> But it doesn't work... !!!
>
> CAn someone help me ?
>
> Mathew
>
>