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.

How do you have these arrays defined? Using a named range or what?

"Rafterrpf" wrote:

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.

Not enough info

--
Don Guillett
SalesAid Software

"Rafterrpf" wrote in message
...
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.