+ Reply to Thread
Results 1 to 3 of 3

Cells don't display formula results

  1. #1
    Registered User
    Join Date
    10-13-2009
    Location
    Great Falls, Montana
    MS-Off Ver
    Excel 2007
    Posts
    32

    Cells don't display formula results

    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
    Attached Files Attached Files
    Last edited by Frankf; 01-04-2010 at 02:51 PM.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Cells don't display formula results

    With no further knowledge I ran the code and the exact same formula's appear with the same results.

    The format is a bit different (decimals), but I see not deviation (at first)

    Could you specify the exact cell we need to look at ?
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    10-13-2009
    Location
    Great Falls, Montana
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Cells don't display formula results

    Never mind.
    I apologize for wasting your time. I'm baffled. I have been working with this for several hours, and only zeros appeared in the cells that had formulas. I closed both workbooks to attach them to my post and just re-opened them. For reasons I do not understand, it works now. I don't know why it works, but I'm glad it does.
    Thanks again for your time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1