PDA

View Full Version : Sleeper: Range.Address length issue



aysherryan
10-05-2018, 04:14 AM
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?

mancubus
10-05-2018, 04:43 AM
another member has opened the same thread with the same wording.
:think:


http://www.vbaexpress.com/forum/showthread.php?63790-Range-Address-length-issue


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

p45cal
10-05-2018, 02:56 PM
cross posted without links: https://www.excelforum.com/excel-general/1248133-range-address-length-issue.html