moving the cell pointer after hitting enter

[mporter501]

Is there a way to get the cell pointer to go for exampl
A1,A2,B1,B2,C1,C2 after data is enter in each cell

 

[JulieD]

Hi

one way - select the cells first in the order specified (using the control
key & mouse) before typing anything and then use the TAB key to move between
them.

Cheers
JulieD

 

[Tom Ogilvy]

Range("A1,A2,B1,B2,C1,C2").Select
Range("A1").Activate

then use the tab key.

 

[mporter501]

I want to save it in a spreadsheet so that it always does this. I ca
only enter 32 cells then it gives me a error after tha

 

[Tom Ogilvy]

You would need to break it into several ranges, then use the union method to
put them together and make the selection

If you want this to be "enforced" so to speak, then you might have to use
some clever code in the SelectionChange event to ensure that the user does
not arrow out of the selection.

The constraint you are running into is probably the string length limitation
of 255 characters. You can certainly have ranges that refer to more than 32
cells.

 

[mporter501]

Still having problems this is what I am trying to do start in cell b3
then c3,b4,c4,b5,c5 all the way down to c38 then back up to E3,f3,e4,f4
all the way down to F38. Can someone please give me some kind of
example on how to do this.