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

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