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 vote302 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote304 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote349 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote339 views1 answer
Vba string
VBA
0 vote334 views1 answer
Excel vba protect sheet
VBA
3 votes316 views1 answer
Excel vba change format of cell
VBA
0 vote303 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote342 views1 answer
Vba random number
VBA
0 vote313 views2 answers
Excel vba protect cells with formula
VBA
-1 vote339 views1 answer
How save excel through visual basic
VBA