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 vote138 views1 answer
Vba refresh pivot table
VBA
0 vote145 views1 answer
Vba integer to double
VBA
0 vote139 views2 answers
Get excel file from email attachment in vba
VBA
1 vote153 views1 answer
Sort using vba
VBA
0 vote144 views1 answer
Vba collection contains
VBA
6 votes154 views1 answer
Excel vba check if a string only contains letters
VBA
31 votes252 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote137 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote149 views1 answer
Vba add spaces
VBA
0 vote134 views1 answer
Afficher un message d'erreur vba
VBA