Printable View
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.:think:
Post the workbook, much more helpful than some pictures.
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.
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.