ARRAY NOT COUNTING A CERTAIN ROW

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Learning arrays. 13
looking a value in an array text values 2
How to write an array to a range without looping 3
Tranpose data from columns to rows 4
Array formulas not working in Excel 2003. 2
sort column corresponding to second column 4
INDEX return multiple columns 1
Using SUM + INDEX in array formula 5

Back
Top