Returning to home base

claudehollett

Board Regular
Joined
Dec 11, 2003
Messages
89
My sheet opens for manual entry in col B. After that manual entry, VBA code takes me to col E for continued manual entry out to col J. After tabbing out to col J and pressing "enter" Excel takes me back to col E on the next row down. Is there a way to leave col J and be automatically returned to col B on the next row down?
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,021
Office Version
  1. 365
What's the code your file is currently using? (right click on the sheet tab and go to "view code")
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
Yes,
You would want to use OFFSET(1,8) to take you where you want to be.

If you don't understand coding, write back I'll give more detail.


Hope this helps,
Michael
 

Forum statistics

Threads
1,148,273
Messages
5,745,794
Members
423,973
Latest member
man_this_is_hard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top