Worksheet_Change event

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:

Please Login or Register  to view this content.

Anyone to help ??

Serge

Please Login or Register  to view this content.