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

1 vote2K views1 answer
Vba Remove Case Sensitivity
VBA
0 vote250 views1 answer
Vba paste values
VBA
0 vote218 views2 answers
Excel vba copy paste after last row
VBA
0 vote236 views1 answer
Vba check if class implements interface
VBA
0 vote222 views1 answer
Vba parameter adodb null value
VBA
3 votes247 views1 answer
Vba continue for each loop
VBA
0 vote245 views1 answer
Power query M substract minimum value of column -dax
VBA
2 votes251 views2 answers
Excel vba if sunday or staurday
VBA
3 votes257 views1 answer
Extract word in a text in excel
VBA
0 vote243 views1 answer
Vba sheet hide unhide
VBA