Hi,
I have a performance problem because the worksheet I use has too many objects.
I have a workbook with 2 worksheets.
In sheet2 there are five columns.Every column has 50 cells below. Some of
then are empty some not. The content of cells change by time.
In sheet1 there are barcode rendering objects 5 columns and 50 rows. That is
250 objects. Every barcode rendering object is linked to a cell in sheet2.
For example the object in column 2, row 5 is linked to a cell in sheet2
column 2 row 5 and so on. The problem is I need to have objects in sheet1 as
many as the non-empty cells in sheet2 because of performance considerations.
Is it possible to Insert then into sheet1 after counting non-empty cells in
sheet2 and exactly at the same row and column number?
Is there another hint to make my worksheet run fuster?
Thanks