如何在Excel中使用2个范围

Here is my code, it works when I use 1 range but if I use 2 or more it does not work. I dont really know how to fix my code. Any help would be very appreciated Here is my code, it works when I use 1 range bu