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 vote280 views1 answer
Vba dictionary clear
VBA
0 vote219 views1 answer
Vba get application version
VBA
0 vote163 views1 answer
Excel autofilter vba
VBA
1 vote235 views1 answer
Vbs run
VBA
0 vote225 views1 answer
Loop through all text boxes in a form vb
VBA
5 votes238 views1 answer
Excel vba low word from Long Integer
VBA
0 vote230 views1 answer
Excel vba combine ranges
VBA
0 vote225 views1 answer
Loop through lines in text file vb net
VBA
1 vote225 views1 answer
Excel vba autofit
VBA
0 vote221 views1 answer
Excel vba linter
VBA