How is the code set up to insert the new row?
For instance if you are finding the nearest blank row using IsBlank() then a
calculated cell won't show up as blank.


"Silena K-K" wrote:

Hi there

I have a template set-up that is used to insert new records into an excel
workbook. However if I set-up columns with calculated fields what I find is
when I enter a new record it is inserted into the next available row that
does not have a calculated field.

Other than deleting the calculated field, is there a way to insert records
into blank rows that have calculated fields?

Thanks Silena