Forum Discussion

Copper Contributor

Oct 17, 2022

Macro to move to another cell after entering date

I have a macro that scans a barcode, looks for the barcode in column A then if found moves across 15 columns & puts the date & time. I'd like it to then move back 11 columns & select the cell ready ...

Macros and VBA

JMB17

Bronze Contributor

Oct 17, 2022

Pip_Payne

Try:

If Not matchedCell Is Nothing Then
     matchedCell.Offset(0, 15).Value = Now()
     matchedCell.Offset(0, 4).Activate
End If