I use a barcode scanner to make entries into an Excel spreadsheet. How do I
get the cursor to move down a column after a scan?

"down a column"?

Try either ActiveCell.Offset(1,0) or ActiveCell(0,1) depending on if you
meant move down a row or across a column.

--
Rick (MVP - Excel)


"DHeckler" wrote in message
...
I use a barcode scanner to make entries into an Excel spreadsheet. How do I
get the cursor to move down a column after a scan?

?B?REhlY2tsZXI=?= wrote in
:

I use a barcode scanner to make entries into an Excel spreadsheet. How
do I get the cursor to move down a column after a scan?

if you are just scanning in. i would try to protect the cells
- highlight your column
- right click on your highlight
- click format cells...
- click the protection tab
- uncheck the locked button
then protect the worksheet depending on what version of excel you have
- in excel 2007 protect is in the Review ribbon
- uncheck "select locked cells"
- in excel 2003 its under Toolsprotection
dont bother to give it a password...just protect it if you have a bunch of
scanning to do in a row.