Excel vba how to reset usedrange

Sub ResetUsedRange(ws As Worksheet)
    If ws.UsedRange.Rows.Count Then ws.UsedRange.Calculate
End Sub
'------------------------------------------------------------------

'Call the above procedure like so:
ResetUsedRange Sheet1

Source: academy.excelhero.com

Similar codes

1 vote330 views1 answer
Add control vb
VBA
0 vote309 views1 answer
Vba copy paste value only
VBA
4 votes320 views2 answers
Vba array length
VBA
1 vote293 views1 answer
Ms access open form to new record
VBA
0 vote346 views1 answer
Excel vba disable screen update
VBA
0 vote318 views1 answer
Le contrôle SpinButton (Toupie)
VBA
1 vote364 views1 answer
Random number generator vb.net
VBA
1 vote371 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote351 views1 answer
Add text to Shape VBA
VBA
1 vote331 views1 answer
How to check is the value enterd is a number or text in vba
VBA