Is their a maximum number of ranges in code

I have code that works except when the line “For Each pair In Range("B30, F30, J30") gets to many ranges put in it. I can put in around 30 or 35 then the code just stops working. Is their a maximum number of ranges or how can I solve this problem?

I have researched this but can only find line-continuation character but that solve the problem.

Please Login or Register  to view this content.

Thanks so much.

Hi TMS

Thank-you so much for your reply. I'm not anyway as knowledgeable as you but if I'm correct the code has to changed to accept up to 100 ranges (your change) am I correct in this? I have a family get together on Sunday and so I can't test this until Monday if that's okay. Hope you have a wonderful weekend.
Scott

Originally Posted by scott1945

I have code that works except when the line “For Each pair In Range("B30, F30, J30") gets to many ranges put in it. I can put in around 30 or 35 then the code just stops working. Is their a maximum number of ranges or how can I solve this problem?

You can still write something like

Please Login or Register  to view this content.

Hi jindon

Thank-you so much for your reply. Tried your suggestion and it works great.

Hi TMS

I tried your suggestion as well and got it to work. Thank-you both so much for all your help. It can be really hard to find these solutions. Have a great day.
Scott