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 vote147 views1 answer
Excel vba existence of a file
VBA
0 vote150 views1 answer
Vba string start with
VBA
0 vote153 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
1 vote143 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote150 views1 answer
Dynamic array vba
VBA
0 vote155 views2 answers
Excel vba number format file size
VBA
0 vote142 views1 answer
Vb net check if file exists
VBA
1 vote169 views1 answer
Extract the second word in a text in excel
VBA
0 vote135 views1 answer
Find days in month vba
VBA
3 votes150 views1 answer
Vba make long from two shorts
VBA