Returning cursor to first cell, next line down

J

Jeff Small

I am using a handheld scanner to record asset/serial numbers of hard ware. I
scan 4 cells worth of data (across) and I would like to find a shortcut or
macro to return the cursor to first cell, next line down. Any ideas ?? I have
scoured the Excel help on the web etc. with no luck. I am using Excel 2000.
 
N

Nick Hodge

Jeff

Make sure you save a copy of the file to try this as I am not sure what else
you are doing... right click on the sheet tab and select 'View Code' and
paste the code in the window that pops up.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Columns(4), Target) Is Nothing Then
Target.Offset(1, -3).Select
End If
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
Top