Calculated fields in Records

  • Thread starter Thread starter Silena K-K
  • Start date Start date
S

Silena K-K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated Field in a Pivottable 3
Copy a calculated field 3
Sequential Numbering in a Template 2
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Calculated field in Pivot Table 2
Mystery field in pivot table 8
Pivot Calculated Field 1
Import Data from Access 1

Back
Top