Tony

Target is the cell that was changed when you use Worksheet_Change. It
doesn't matter what the ActiveCell is, Target points to the cell that fired
the event. SpecialCells(xlCellTypeLastCell) returns the last cell in the
worksheet, so you don't want to use that.



'HERE I AM USING SpecialCells(xlCellTypeLastCell) TO GET THE LAST
CELL
'AND End(xlToRight) TO GET THE GET THE LAST CELL ON THAT ROW WHICH
HOLDS THE entryID
x = ActiveCell.SpecialCells(xlCellTypeLastCell).End(xl ToRight)

x = Target.End(xlToRight).Value

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com