Go to Differant Cells After entering

M

mporter501

I am setting up a spreadsheet for measuring parts. I am using a gag
input tool which enters data into excel by a push of a button. I nee
help with getting the cell pointer to go from b3,c3,b4,c4 and so on
all the way to c38 then to e3,f3,e4,f4 and so on all the way to f38.
am new at VBA. Please if anyone can help
 
R

Ron de Bruin

Hi

One way is to select the range first and use the Tab key.

Sub test()
Range("B3:C38,E3:F38").Select
Range("B3").Activate
End Sub
 
M

mporter501

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,b10,c10,b11,c11,b12,c12,b13,c13,b14,c14,b15,c15,b16,c16,b17,c17,b18,c18,b19,c19,b20,c20,b21,c21,b22,c22,b23,c23,b24,c24,b25,c25,b26,c26,b27,c27,b28,c28,b29,c29,b30,c30,b31,c31,b32,c32,b33,c33,b34,c34,b35,c35,b36,c36,b37,c37,b38,c38,e3,f3,e4,f4,e5,f5,e6,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,f19,e20,f20,e21,f21,e22,f22,e23,f23,e24,f24,e25,f25,e26,f26,e27,f27,e28,f28,e29,f29,e30,f30,e31,f31,e32,f32,e33,f33,e34,f34,e35,f35,e36,f36,e37,f37,e38,f38").Select
Range("B3").Activate

End Su
 
Top