Hello All,

I want my change event to fire when pasting values, lists of values, and auto-filling. Does anyone know the best way to handle it? I need the cell range name for each cell to be named the same as the cell value. The worksheet is linked to an access document and something with the way link is set up requires the name to equal the value (not sure why...i didnt set up the accdb).

'Here is my current code:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 3 Then
ThisRow = Target.Row
If Target.Value <> "" Then
ActiveWorkbook.Names.Add Name:=Target.Value _
, RefersTo:=Cells(ThisRow, Target.Column)
End If
End If
End Sub