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 vote157 views1 answer
Change "location" of binding navigator vb
VBA
0 vote157 views1 answer
Excel vba center userform
VBA
0 vote229 views1 answer
Excel vba add reference programmatically
VBA
5 votes169 views1 answer
Xl vba double quotes in string literal
VBA
0 vote172 views1 answer
Excel vba protect sheet
VBA
0 vote173 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote176 views1 answer
Vbnet line chart showing extra space
VBA
0 vote143 views1 answer
How to make a if statement with vbs
VBA
1 vote170 views1 answer
Excel vba unload userform
VBA
0 vote175 views1 answer
Convert number to minutes in vba
VBA