Prev: Excel 2007 data query parameter issue
Next: Copy Picture problems
From: IMcC on 27 Mar 2010 06:30
I need to keep a spreadsheet in manual recalc mode but would like it to
automatically recalc when rows in a group are hidden or unhidden.
From: Don Guillett on 27 Mar 2010 08:50
One way.
'============
Public rd
Sub ifrowhidechnage()
hr = Cells.Count
'MsgBox hr
vr = Cells.SpecialCells(xlCellTypeVisible).Count
'MsgBox vr
'msgBox rd
If hr - vr <> rd Then MsgBox "hi"
rd = hr - vr
End Sub
'========
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"IMcC" <IMcC(a)discussions.microsoft.com> wrote in message
news:A3B3831C-4BB7-4160-989D-B2395F426F74(a)microsoft.com...
>I need to keep a spreadsheet in manual recalc mode but would like it to
> automatically recalc when rows in a group are hidden or unhidden.

 | 
Pages: 1
Prev: Excel 2007 data query parameter issue
Next: Copy Picture problems