try this
set sheet calculation to manual
'application.Calculation=xlCalculationManual (VBA)
sheet calculates only when the user presses the Shift + F9 button.
On Mon, Jun 27, 2011 at 6:08 PM, crossy75 wrote:
> I have this bit of code in a spreadsheet - it is used with a formula
> to coun
I have this bit of code in a spreadsheet - it is used with a formula
to count the number of visible rows. This is useful in accounts where
people hid things thus counting what you see isnt always what you get!
'Function Vis(Rin As Range) As Range
'Returns the subset of Rin that is visible
