RE: "COMPRESSING" A LARGE SHEET WITH 31,000 ROWS OF DATA, YET NOT LOSING SEARCH, COPY ACCESS CAPABILITY, ETC....

[chazrab]

Sheet2 has 31000 rows in 4 columns, A, B, C AND D. The Rowsource property for the FIND method will always be the same:

Sheets("Sheet2")!B1:G31103.

(Column G does not have every row populated with 31,103 rows. Columns B through E does.

Is there a way to compress this sheet (i.e., like a zip file) so the file won't be so large, making the code work
more efficiently, without losing any application design capability/efficiency ?

I can't be the only one who may have or had this issue, maybe with not so many rows.

Please help with any suggestions and/or ideas.

Thanks for anyone's help.
cr

 

[mumps]

Do a little research on using arrays. You could store all the data in your sheet in an array. This stores the data in memory. You can then manipulate the data in memory which is very fast instead of having to repeatedly access the worksheet directly which slows thing down.

 

[Fluff]

@chazrab
Maybe you didn't see this post in your last thread. PLEASE TELL ME THIS IS POSSIBLE OR NOT POSSIBLE WITH A USERFORM TEXTBOX TEXT...

 

[chazrab]

@chazrab
Maybe you didn't see this post in your last thread. PLEASE TELL ME THIS IS POSSIBLE OR NOT POSSIBLE WITH A USERFORM TEXTBOX TEXT...

I saw it only now and responded only now. As you will see, I will comply. I play by the rules. My pop up reminder is set this
way: "Do not use all caps when composing thread titles"

cr

 

[chazrab]

Do a little research on using arrays. You could store all the data in your sheet in an array. This stores the data in memory. You can then manipulate the data in memory which is very fast instead of having to repeatedly access the worksheet directly which slows thing down.

Thanks mumps. Will look into this today.
cr