OK this is what I tried It gives me a Method'Range' of object'_Globa
Failed. Is my range to big? Do I need to break it into groups? If s
how do I do That?
Sub TEST()
Range("b3,c3,b4,c4,b5,c5,b6,c6,b7,c7,b8,c8,b9,c9,b 10,c10,b11,c11,b12,c12,b13,c13,b14,c14,b15,c15,b16 ,c16,b17,c17,b18,c18,b19,c19,b20,c20,b21,c21,b22,c 22,b23,c23,b24,c24,b25,c25,b26,c26,b27,c27,b28,c28 ,b29,c29,b30,c30,b31,c31,b32,c32,b33,c33,b34,c34,b 35,c35,b36,c36,b37,c37,b38,c38,e3,f3,e4,f4,e5,f5,e 6,f6,e7,f7,e8,f8,e9,f9,e10,f10,e11,f11,e12,f12,e13 ,f13,e14,f14,e15,f15,e16,f16,e17,f17,e18,f18,e19,f 19,e20,f20,e21,f21,e22,f22,e23,f23,e24,f24,e25,f25 ,e26,f26,e27,f27,e28,f28,e29,f29,e30,f30,e31,f31,e 32,f32,e33,f33,e34,f34,e35,f35,e36,f36,e37,f37,e38 ,f38").Select
Range("B3").Activate

End Su

--
Message posted from http://www.ExcelForum.com