I need to select ranges concatenating addresses in VBA

0

I have a sub in VBA that does several calculations to get into an address list of ranges     listAddresses="$ A $ 1, $ H $ 3, $ V $ 1, $ M $ 16, $ A $ 21, $ B $ 13, $ H $ 88 ..... $ T $ 44"

With this list I need to select all ranges. So I tried -     Range (listAddresses) .Select

However, when I have more than a certain number of Ranges, VBA and VB (I tried both) give error and do not select any cells.

    
asked by anonymous 06.03.2017 / 12:55

0 answers