after scanning into a cell, how do I get it to move to the right automatically before hitting the enter key to move down to the next row?
after scanning into a cell, how do I get it to move to the right automatically before hitting the enter key to move down to the next row?
You could probably use the Worksheet_Change event to do that, but the post lack sufficient info to offer any code for it.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks