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

22 votes304 views1 answer
Xl vba check for folder
VBA
0 vote155 views1 answer
Vba shape transparent
VBA
3 votes148 views1 answer
Vba not equal
VBA
0 vote153 views1 answer
Vba change named range address
VBA
1 vote165 views1 answer
Export datagridview to excel vb.net
VBA
5 votes155 views1 answer
Excel vba high word from Long Integer
VBA
0 vote154 views1 answer
Vba sheet visible
VBA
0 vote150 views2 answers
Get excel file from email attachment in vba
VBA
1 vote149 views1 answer
What does vbs stand for
VBA
0 vote167 views1 answer
Default host vbox address
VBA