G
Guest
2057 ARRAYS in a work book used for past 3 years. End of year workbook saved
under that year and then re-named to current year. All data is deleted
(delete contents). Up to Row 45 all ARRAYS working correctly. One ARRAY uses
Columns B, C, and F with other ARRAYS using incommon Colmns C, and F. All
ARRAYS except for first work fine.
Data that is inputted into Row 45 is copied and then pasted into Row 46 and
the ARRAY works. The ARRAY works for all data prior to and after Row 45. If
data from Row 45 is copied and pasted into Row 46 and then Row 45 is deleted
(changing Row 46 to Row 45) the ARRAY no longer works.
under that year and then re-named to current year. All data is deleted
(delete contents). Up to Row 45 all ARRAYS working correctly. One ARRAY uses
Columns B, C, and F with other ARRAYS using incommon Colmns C, and F. All
ARRAYS except for first work fine.
Data that is inputted into Row 45 is copied and then pasted into Row 46 and
the ARRAY works. The ARRAY works for all data prior to and after Row 45. If
data from Row 45 is copied and pasted into Row 46 and then Row 45 is deleted
(changing Row 46 to Row 45) the ARRAY no longer works.