Results 1 to 1 of 1

Excel Version & Table Formula

Threaded View

emp1346 Excel Version & Table... 02-18-2014, 12:27 PM
  1. #1
    Registered User
    Join Date
    11-16-2013
    Location
    OK
    MS-Off Ver
    Excel 2013
    Posts
    33

    Angry Excel Version & Table Formula

    So I have VBA I wrote in Excel 2013 that works just fine, but which Excel 2007 apparently doesn't like.

    Here is the code:

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    Cells(radd, [schedend].Column + 8) = "=IF(ISBLANK([@VOLUME]),D" & radd + 1 & ",[@VOLUME])"

    This is an excerpt from a table entry macro, and the table formula will not go into the cell. I tried to troubleshoot it, and was able to use non-table formulas without problems. For example Excel 2007 likes this one just fine:

    Cells(radd, [schedend].Column + 8) = "=IF(A1=""workdamnyou"",D" & radd + 1 & ",12345)"
    So thoughts on how I make the table formulas work in Excel 2007???


    Edit: Also, how does any of this affect users still on Excel 2003?
    Last edited by 6StringJazzer; 02-18-2014 at 01:14 PM. Reason: question addendum; code tags(6SJ)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to determine version of excel version
    By dare2join in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 01:21 AM
  2. Excel Version:Dynamic Pivot table
    By PaulWi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2006, 07:09 AM
  3. VLookup Formula Excel Version 2002
    By biz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  4. [SOLVED] Recover earlier version of excel sheet after new version saved?
    By stephanie38 in forum Excel General
    Replies: 3
    Last Post: 06-16-2005, 11:05 PM
  5. Replies: 1
    Last Post: 05-11-2005, 11:06 AM

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