Thread
:
Summing non hidden values in a range
View Single Post
#
14
May 2nd, 2006, 12:56 PM posted to microsoft.public.excel.misc
Bob Phillips
external usenet poster
Posts: n/a
Summing non hidden values in a range
Problem with a UDF is that it is not recalculated if a new row gets
hidden/unhidden. You would have to force it somehow.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Ardus Petus" wrote in message
...
I don't have XL 2003 either..
Sounds like you need an UDF.
Here is some code you can paste in a Module
'------
Function TOTAL_VISIBLE(rng As Range) As Long
Dim c As Range
For Each c In rng
With c
If Not .EntireColumn.Hidden Then
TOTAL_VISIBLE = TOTAL_VISIBLE + .Value
End If
End With
Next c
End Function
'---------
"starguy" a écrit
dans
le message de news:
...
what should I do. I need it... any body esle...
--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread:
http://www.excelforum.com/showthread...hreadid=537953
Bob Phillips
View message headers