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

0 vote226 views1 answer
Vba cell all borders
VBA
0 vote216 views1 answer
Vb run command
VBA
0 vote209 views1 answer
Excel vba automatic calculation
VBA
0 vote219 views1 answer
Pivot data source not accepting table named range vba
VBA
2 votes197 views1 answer
Vba array contains
VBA
0 vote211 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote222 views1 answer
VBA
VBA
0 vote157 views1 answer
How to make a if statement with vbs
VBA
0 vote216 views1 answer
Vb ternary
VBA
1 vote160 views1 answer
Ms access open form to new record
VBA