I'm using VBA with a change event on my main worksheet as follows: [remarks follow each line]
Upon changing cell I7, a new row is added to the table, the date and new stock price are put into column A and B and the formulas in columns D and E are inserted and update with the appropriate 15 and 30 day average, incrementing the rows used for the calculation. When I changed the 15 day formula to a 10 day formula and copied it down the column, everything still worked as before, but in the new row, the 10 day column inserted the old 15 day formula. I also got the "error" that the formulas that I copied were inconsistent with the column formula.
My real question is: How do you change the column formula for a column in a table so when the table auto expands it inserts the new formula?
Bookmarks