I have a macro that will copy data from a source worksheet and paste it into a destination sheet. It also populates cells in the same rows as the copied data with formulas. All is well, but the results of the formulas are not shown in the cells. The destination sheet cells with formulas only display zeros. If you click on the cells, the correct formulas are shown in the formula bar. And if you click the fx button to bring up the formula wizard, the formulas are evaluated correctly.
Both my source sheet and destination sheet are attached. The destination sheet should look like the source sheet, if the formula results are shown correctly.
I checked formatting, and don't see any reason that the results of the formulas are not shown. I need the formulas as some of the data cells might be altered and I want the cells with formulas to display updated values.
Thank you so much for your help. This site has been a godsend for me as I try to learn VBA.
Frank
Bookmarks