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 vote132 views1 answer
Average vba
VBA
1 vote129 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote126 views1 answer
Vba open report
VBA
0 vote135 views1 answer
Vba word open document read only
VBA
0 vote143 views1 answer
Date as number vb
VBA
0 vote130 views1 answer
Excel vba calculate
VBA
0 vote127 views1 answer
Vb window.minimize
VBA
0 vote131 views1 answer
How to get the value of optionbutton in vba
VBA
13 votes258 views2 answers
Vba write text file
VBA
4 votes122 views1 answer
Excel vba check cell not empty
VBA