Here are my cells, sorry there are so many.

C3-C7, L3-L7, W3-W8, (A10, B10, C10, E10, J10, L10, U10, Repeat through 21),
A23, A25, C32, A34, B34, D34, B35, B36, H26-H30, H340H38)

Thanks so much for taking the trouble to help me. Also, I would need the
freedom to click on individual cells after the (script ?) is done.

"Gord Dibben" wrote:

You will have to be a little more specific.

All we know now is that you want to fill cells top to bottom on the left
then top to bottom on the right on two halves of a worksheet.

Where is top and bottom on first half of form and top and bottom of second
half of form?

Where is right and left on both halves?

Sounds like 4 distinct ranges.

Please use cell addresses in your description.

Like A1:A20 and H1:H20 etc.

Are the cells contiguous in each range?


Gord


On Mon, 6 Apr 2009 14:36:08 -0700, Rita
wrote:

Thank you for your reply. I have at least triple that amount. Any other
easy ideas for a VB newby?? Thanks.

"Gord Dibben" wrote:

You could use a named range if you don't have more than about 45 cells to
move to.

Elsewise you will need VBA

Post the exact ranges and order of tabbing.


Gord Dibben MS Excel MVP

On Mon, 6 Apr 2009 11:21:01 -0700, Rita
wrote:

Can anyone help me with this??

"Rita" wrote:

I have created a complex invoice template using Excel. I would like to set
the order of tabbing if possible, so it goes from top to bottom on the left
and then top to bottom on the right for the top half of form and then the
same for the bottom half of form. Is there any way to set this up? Thanks!