Vlookup and file size

I did try to remove unused cells, but it doesn't seem to change the file size. The size of the file does not change until I use the vlookups, so I think it must have something to do with the data that I copied and pasted special back over the vlookups.

You did save the workbook after deleting the unused range?


Gord

On Mon, 19 Dec 2005 14:30:10 -0600, Alex532
<Alex532.20b0wa_1135024500.7027@excelforum-nospam.com> wrote:

>
>I did try to remove unused cells, but it doesn't seem to change the file
>size. The size of the file does not change until I use the vlookups, so
>I think it must have something to do with the data that I copied and
>pasted special back over the vlookups.

That is a good question. I went back and did it again and made sure I saved it, but it is still the same size. That does not surprise me though, since the unused space it is deleting never had any data in it to begin with.

I'm out of suggestions except for you checking the macro code to see what gets
swapped around when you do the paste special values.

One more thing.

Where does CTRL + End take you on your worksheet?

End of data or somewhere else?

Any objects embedded in the workbook on any sheet(s)?


Gord


On Mon, 19 Dec 2005 14:49:47 -0600, Alex532
<Alex532.20b1lb_1135025401.455@excelforum-nospam.com> wrote:

>
>That is a good question. I went back and did it again and made sure I
>saved it, but it is still the same size. That does not surprise me
>though, since the unused space it is deleting never had any data in it
>to begin with.