copy paste with min data transfer

[dude]

I have this macro that opens a specified excel file (a large one) i
order to import information from it to another excel.

To import the information I use the copy usedarea function and paste i
as values in the target.

For some reason this macro results in my target file becoming hug
(lots of MB). When I try doing the same procedure manually (copy rang
- paste special values. The result is different and does not import an
access MBs.

Is there a way to import data in the minimum storage capacity?

Thanks

 

[Dave Peterson]

When you do this manually, how do you find the used range?

If you locate it yourself, maybe you're not doing the same thing that excel
does.

ctrl-end will take to you the last used cell.

If that's way past what you expect, maybe a visit to Debra Dalgleish's site will
help:

http://www.contextures.com/xlfaqApp.html#Unused

(She has some code there that you may want to incorporate into your macro.)