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

M

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell values to an array, then array transpose to another workbook 8
Arrays containing variable sheets 2
Pasting a cell into bookmarked table from excel vba 1
Code copies twice...? 13
Strange pasting array to cells behavior 2
VBA code for pasting links -- modifying RDB code for summary workbook 11
Look Up Formula With Veried Search Range 2
Select specific sheets and copy to new workbook 2

Top