+ Reply to Thread
Results 1 to 10 of 10

Changed to Office 2007 from 2003

  1. #1
    Registered User
    Join Date
    11-04-2013
    Location
    Berkshire
    MS-Off Ver
    Excel 2007
    Posts
    6

    Changed to Office 2007 from 2003

    when I used 2003 I used =citems(a1) to count how many numbers were entered into cell A1 (ie 15+15+15) would read (3), now when I type it into a cell in 2007 it just says NAME? . any ideas?.
    Thanks in advance,Barry.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Changed to Office 2007 from 2003

    =citems(a1) is not a native function to excel it must have been a user defined function
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    11-04-2013
    Location
    Berkshire
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Changed to Office 2007 from 2003

    It was built by some one else, so how can I get it to work in the one I'm attempting to build.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Changed to Office 2007 from 2003

    since it was available to all workbooks it may have been an add in have a look in excel options/advanced add ins see if there is something in there that refers to it

  5. #5
    Registered User
    Join Date
    11-04-2013
    Location
    Berkshire
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Changed to Office 2007 from 2003

    Ok I'll do that, Thanks.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Changed to Office 2007 from 2003

    Open an old workbook in which the function works. In the Names box, left of the formula bar, type the function name and press Enter. That will take you to the code.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Registered User
    Join Date
    11-04-2013
    Location
    Berkshire
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Changed to Office 2007 from 2003

    Yes found it thamk you very much. Barry.

  8. #8
    Registered User
    Join Date
    11-04-2013
    Location
    Berkshire
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Changed to Office 2007 from 2003

    Ok I got too cocky there, I've found the code, but how do I put it into the new sheet (excel 2007), Barry.

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Changed to Office 2007 from 2003

    Copy the code, go to the new file, do Alt+F11 to open the VBE, Insert > Module, paste.

  10. #10
    Registered User
    Join Date
    11-04-2013
    Location
    Berkshire
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Changed to Office 2007 from 2003

    Thank you, it is working now much appreciated. Barry.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro built with Office 2003 not working on Office 2007
    By pako87 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-02-2009, 08:12 AM
  2. office 2003 and office 2007
    By walid66 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2008, 02:47 AM
  3. 2003 to 2007 commands that changed
    By cbh35711 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2008, 04:22 PM
  4. Office 2003 and 2007
    By René in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2006, 05:10 AM
  5. [SOLVED] Performance not upto Office 2003 standards in Office 2007
    By Mangal Singh in forum Excel General
    Replies: 11
    Last Post: 05-29-2006, 08:00 PM

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