VBA Code required..

[mdileep]

I have an Excel workbook that contains 31 sheets. I fill data on each sheet in the range from B6 to CK6, using the Tab key to move the cursor. I want to move the cursor from CK6 back to B7, and then from CK7 to B8, and so on until CK29, using VBA code or any shortcut method. Can anybody help, please?

 

[bobsan42]

Normally if you use Tab to move all the way from B6 to CK6 then if you press Enter after filling CK6 the cursor will move back to B7.
I am not sure if Excel Options > Advanced > Cursor movement> Logical has any effect on this behavior.
Other keyboard shortcuts to move fast across the sheet: Ctrl + Any Arrow key - this will move you to the next Blank/Non-blank cell in the direction of the arrow .
pressing Home will take to column A on the active row. Ctrl+Home takes you to A1.
Ctrl+End takes you to the bottom-right cell of the sheet's UsedRange.
If you hold down Shift during such movements you get the added benefit of selecting the cells you skip.
Ctrl+PageUp / Ctrl+PageDown will let you switch to the next sheet on the Left/Right of the active one.
etc....

IMO involving VBA for this has more drawbacks than benefits.
Search the web for Excel keyboard Shortcuts - surely you will find plenty of sources. Or try this one - it seems to be quite comprehensive.

 

[mdileep]

Normally if you use Tab to move all the way from B6 to CK6 then if you press Enter after filling CK6 the cursor will move back to B7.
I am not sure if Excel Options > Advanced > Cursor movement> Logical has any effect on this behavior.
Other keyboard shortcuts to move fast across the sheet: Ctrl + Any Arrow key - this will move you to the next Blank/Non-blank cell in the direction of the arrow .
pressing Home will take to column A on the active row. Ctrl+Home takes you to A1.
Ctrl+End takes you to the bottom-right cell of the sheet's UsedRange.
If you hold down Shift during such movements you get the added benefit of selecting the cells you skip.
Ctrl+PageUp / Ctrl+PageDown will let you switch to the next sheet on the Left/Right of the active one.
etc....

IMO involving VBA for this has more drawbacks than benefits.
Search the web for Excel keyboard Shortcuts - surely you will find plenty of sources. Or try this one - it seems to be quite comprehensive.

Thanks, But by use Tab to move all the way from B6 to CK6 then if I press Enter after filling CK6 the cursor will move back to CK7.

 

[bobsan42]

IMO, it is pointless for Enter to do the same thing as Tab.
So you can change Excel Options like this:

... or Use the Ctrl+Arrow shortcuts.

 

[mdileep]

I have hidden all columns after CK:6 and protected the sheet. By doing this, my cell selection moves as I desire.
Thanks

 

[bobsan42]

I have hidden all columns after CK:6 and protected the sheet. By doing this, my cell selection moves as I desire.
Thanks

It's good you found your own solution.