+ Reply to Thread
Results 1 to 2 of 2

Using underscore ("_") with Cells().formula, to divide the code in multiple lines

  1. #1
    Forum Contributor Mayda89's Avatar
    Join Date
    09-13-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    192

    Using underscore ("_") with Cells().formula, to divide the code in multiple lines

    Hi,

    I have a code which works perfectly fine, except, the code is too long for one line, so therefore I want to make use of the underscore "_" character to divide the code into a few lines.

    This is the simplified version of my code (I simplified it to avoid clutter):
    Please Login or Register  to view this content.
    As I said above, this works fine, but I want to use the underscore character to divide it into multiple lines

    I have tried the following, but it doesn't work.
    Please Login or Register  to view this content.
    If I have helped, Don't forget to add to my reputation (click on the star icon below the post).
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved).
    Use code tags when posting your code.

  2. #2
    Forum Contributor Mayda89's Avatar
    Join Date
    09-13-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Using underscore ("_") with Cells().formula, to divide the code in multiple lines

    Ok, I found the solution. I need to use the following code:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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