Multiple intersecting ranges

Currently this code works, but as stated in the code, it only works for anything row 54 and after, column E. I would like this to function for anything row 54 and after for column G as well. After multiple attempts, I am reaching out to see if I can get some help. Thanks in advance.

Please Login or Register  to view this content.

If you want it to work on bot cols E & G try

Please Login or Register  to view this content.

Originally Posted by Fluff13

If you want it to work on bot cols E & G try

Please Login or Register  to view this content.

I did want both, I should have made that more clear.

Thank you both!