I am using Excel 2016 and have written VBA code to insert a blank line in a table. When the blank line is inserted, one of the cells also gets filled with the value 39.08 which, affording to the cell value comes from -35.5 + 5.58. The uploaded Word file shows the problem in more detail. I have no idea why this value appears in that cell. I would be grateful for any advice.
Post the workbook, much more helpful than some pictures.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I have uploaded an anonymised worksheet. Hopefully it will help to identify where the problem value in the cell comes from.
Very odd isn't it? When I did it, it created a formula 0f =33.5+5.58.
I can only think there was some memory formula in the table, but the way I 'sorted' it was to remove the new line. then delete all the 33.5 values, then reinserted them. When I inserted a line then, it left that column blank.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I tried deleting all the values in the table and then inserting new rows and then deleting the rogue values/rows. Repeating the inserting of rows got me the same problem (see image). Please provide details of exactly how you managed to fix the problem.
I think I have managed to solve the problem. I converted the table to range values and then set up the table again. When I inserted a new row the rogue value did not appear. Thanks for you help.
Posting Permissions
Reply With Quote
