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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"mporter501 " wrote in message ...
I am setting up a spreadsheet for measuring parts. I am using a gage
input tool which enters data into excel by a push of a button. I need
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. I
am new at VBA. Please if anyone can help.


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