Can't say I blame you for that. Instead I have set out to present the problem in a very simple fashion, which I should have done in the first place. The attached macroless worksheet demonstrates the problem I have encountered. It only occurs when adding the first line to an "empty" table but of course the corrupt formula persists for subsequent line additions. It only occurs with the A1:A2 format.
|