PDA

View Full Version : Range.Address length issue



nikki333
10-04-2018, 01:01 PM
Hi folks

I'm trying to calculate averages for some ranges (columns) depending on their heading, and then put the formula somewhere in the first columns of the sheet.

Therefore i walk through each column in question and if it fulfills my criteria, it's going to be added to my Union range (eg. myrange = union(myrange, newrange). This union range I then use in a formula and put it into the cell in question.

However, it seems that, in my case, each range comprises 63 cells, and after 19 of those ranges VBA just won't do it anymore.

Any ideas how to overcome this issue?

Many thanks and cheers

Jan Karel Pieterse
10-05-2018, 02:44 AM
You haven't shared any code, this makes it very hard to answer your question. ALso, some sample data will help.