Hi,

I have a table in a worksheet, to which I add a row by entering data in the leftmost cell (column A, row n). It naturally fires the Worksheet_Change event but instead of settingthe Target to cell An, it sets it to cell Bn (2nd. column). I have 25 columns in the table and most of them have formulas that are calculated when the new row is generated. It may be caused by the other cells of the row being updated and probably Bn being updated last??

How can I force <Worksheet_Change event> to set Target to the actual cell where I am entering data ??

Code starts like so:

Public Sub Worksheet_Change(ByVal Target As Range)
     myRowNumber = Target.Row
    
If Target.Cells.Count = Range("Planned_Jobs").Columns.Count Then 'attempt to delete a row in the table
Exit Sub
    
    Set isect = Application.Intersect(Target, Range("A:A"))
Anyone to help ??

Serge