Results 1 to 8 of 8

SUM a dynamic range not including hidden cells

Threaded View

  1. #8
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: SUM a dynamic range not including hidden cells

    A combination of UDF and worksheet events given .Have a trail.
    code for UDF
    Function SumVisibleClms(SumRng As Range) As Double
    
    Application.Volatile
    Dim cel As Range
    
    For Each cel In SumRng
    If cel.EntireColumn.Hidden = False Then SumVisibleClms = SumVisibleClms + cel.Value
    Next cel
    
    End Function
    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. Dynamic Range Sizes, including blanks
    By Speshul in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-12-2014, 10:52 AM
  2. Replies: 0
    Last Post: 01-15-2014, 05:17 PM
  3. Dynamic Print Range not including blank rows with formulas
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 11:49 AM
  4. Copy & Paste data INCLUDING hidden cells? (Excel 2003)
    By EI-ALEX in forum Excel General
    Replies: 2
    Last Post: 08-09-2010, 03:52 PM
  5. [SOLVED] Create dynamic dropdown from range including blanks
    By Mike Mick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-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