+ Reply to Thread
Results 1 to 3 of 3

VBA =SUM issues

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    phoenix, arizona
    MS-Off Ver
    Excel 2012
    Posts
    71

    VBA =SUM issues

    I'm sure this has a very simple solution that I'm overlooking and/or overthinking. What is wrong with this vba formula?

    [e8].Formula = "=sum(e2:" & [e2].End(xlDown) & ")"

    I've tried a number of variations with Range and quotes. I gave up.

    I'd actually like to sum "E2:E7" and go all the way down to column Z. The "E7", however, is variable. It may be "E3" on one workbook or "E100" on another. Is there a more elegant solution than VBA copy/pasting this all the way down?

    Thank you.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: VBA =SUM issues

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA =SUM issues

    FWIW:

    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)

Similar Threads

  1. [SOLVED] if then issues
    By uplandpoet in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 07-23-2014, 11:38 AM
  2. Replies: 3
    Last Post: 07-16-2014, 01:50 AM
  3. Data Validation List Issues/Sorting Issues
    By taylorbe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2014, 09:53 AM
  4. IF issues
    By Dbeethekidd in forum Excel General
    Replies: 2
    Last Post: 03-11-2011, 08:22 AM
  5. #REF Issues
    By kendo2748 in forum Excel General
    Replies: 2
    Last Post: 05-22-2009, 09:18 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