+ Reply to Thread
Results 1 to 4 of 4

vba help with sum visible columns

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    105

    vba help with sum visible columns

    hello

    Need to change the format of the formula from =SumVisCells(A3:H3) to =SumVisCells(A2,C2,E2,G2) as i need to pickup alternative visible columns with sumviscells not takinig into account hidden columns. Thanks

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by nd4spd; 08-01-2011 at 11:02 AM.

  2. #2
    Forum Contributor
    Join Date
    04-18-2011
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    105

    Re: vba help with sum visible columns

    file attached

  3. #3
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    1,252

    Re: vba help with sum visible columns

    Hi,

    See how you get on with this:
    Please Login or Register  to view this content.
    Hope that helps,

    Colin

    RAD Excel Blog

  4. #4
    Forum Contributor
    Join Date
    04-18-2011
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    105

    Re: vba help with sum visible columns

    Thanks Colin it works great !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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