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 vote184 views2 answers
Open url from vba
VBA
0 vote222 views1 answer
Windows Forms dark title bar
VBA
0 vote197 views1 answer
Vba nested dictionary
VBA
8 votes200 views1 answer
Excel vba determine number of elements in a 1D array
VBA
5 votes176 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote131 views1 answer
How to make a if statement with vbs
VBA
8 votes190 views1 answer
Run command pormpt in background windows
VBA
0 vote182 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote188 views1 answer
Vba find last column in a row with data
VBA
1 vote176 views1 answer
Excel vba make cell visible
VBA