Results 1 to 15 of 15

Excel Cell formula issue

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    14

    Excel Cell formula issue

    Hi,

    I am facing problem with cell formula to capture in macro, complete formula not populating while recording macro.

    Lines are disconnecting, (Ex: In code one of the lines has "CONCATENATE(LEFT(R2,33)" , it's coming as "CONCAT"& _" but in next line there is no continuation)

    Attached is the formula and output macro code. Is there any limitation on cell formula lines? even if i changed continuously without spaces it's not working.

    I am using 2010 excel, please help me on this.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-23-2010, 11:17 AM
  2. Issue with Formula that Reads a Cell with Character 10
    By Caligula in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-22-2008, 04:57 PM
  3. VBA/Excel formula issue
    By spinkung in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2007, 08:01 AM
  4. Cell = Formula issue
    By EFGMan in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 01-11-2007, 06:56 PM
  5. Excel Formula Issue
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 08-16-2006, 06:50 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