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.
Thanks so much.Please Login or Register to view this content.
Bookmarks