Results 1 to 17 of 17

String and Value workbook reference

Threaded View

  1. #5
    Registered User
    Join Date
    10-04-2013
    Location
    Irving, Texas
    MS-Off Ver
    Office 2003-07-10-13
    Posts
    34

    Re: String and Value workbook reference

    On the other hand, attached is a macro enabled file that uses some code (initiated by a button click) that will count all the cells with numeric contents and adds the value from the "Change Value" cell.
    Any number of cells in column A can have values and they can be in any position in column A.
    Text values in column A will be ignored.
    Any error, including if the value in Change value is not numeric, will end the code.
    If you want to add values, place a positive value in Change Value cell.
    If you want to subtract values, place a negative value in Change Value cell.

    Edit: Needed to add something to the file.
    If you already downloaded it, delete it.
    I am trying to upload the corrected version
    Last edited by Bilbo_Baggins; 10-15-2013 at 10:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 06-01-2013, 05:04 AM
  2. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  3. Replies: 2
    Last Post: 05-01-2009, 07:06 PM
  4. use a string to reference a sheet
    By AustinBrister in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2008, 02:00 PM
  5. Replies: 1
    Last Post: 02-03-2006, 12: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