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 vote190 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote170 views1 answer
Vba open report
VBA
0 vote180 views1 answer
Remove first character from string vb
VBA
0 vote163 views1 answer
Excel vba center userform
VBA
0 vote162 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote174 views1 answer
Vba nested dictionary
VBA
4 votes170 views1 answer
Excel vba determine number of elements in an array
VBA
11 votes332 views1 answer
Excel vba How to URL encode a string
VBA
0 vote204 views2 answers
Get unique random number in vb.net
VBA
6 votes186 views1 answer
Excel vba get the path of current workbook
VBA