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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,105
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,182,194
Messages
5,934,196
Members
436,935
Latest member
Fergjosh97

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