One way is to use a "named range".


Check out this old post:


http://tinyurl.com/39vzv


--
HTH,


RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"jhells" wrote in message
...
I have three colums. I need the tab order to go down colum one, three
rows.
Then wrap up the three rows in colum two, and then back down three rows
again
(in colum two). Same thing in colum three. I have done programming in
Access, but I'm really stumped on how to do this in Excel!?!?! Please
help
me if you can. Thanks