Retrieving data from other excel sheets.

If I'm reading it right you're just trying to copy the range A1:J100 from one workbook to another? Is that correct?

Please use code tags when posting code.

Dom

Yes I guess I am. But this is only the first step in what I want to do.
I aim at retrieving data from one set of accounts based on a certain account number.
E.g. there are 10000 different account numbers, but we only want to insert those with account numbers between 1-1000 in f.ex. the cell named "revenue" and 1001-2000 in another cell etc.

My idea was that I needed to make a do loop, and then start by actually being able to get the numbers imported. After that I plan on adding if loops or something of the sort thereby achieving my goal.

But, as I wrote above, my (very simple) code doesn't work properly, and I have no idea why.
Thanks for your help,
Pelle

PS.
I am using this "GetValue" function I found somewhere:

Please Login or Register  to view this content.

That makes things a bit clearer. It's not a good idea to have subs and functions with the same name, in the same way that you should avoid defining anything as a reserved word.

Looking at the function you just posted I think this line:

Please Login or Register  to view this content.

should just be:

Please Login or Register  to view this content.

I think the code you wrote should be fine after that although you should get used to declaring your variables at the beginning of the procedure like this:

Please Login or Register  to view this content.

I did a quick test and it pulled the values in fine from my file.

Hope it helps,

Dom