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 vote220 views1 answer
Excel protect cells with formulas
VBA
0 vote212 views1 answer
Vbnet check if string is only symbols
VBA
0 vote249 views1 answer
Style percent not found vba
VBA
1 vote223 views1 answer
Add a index column power bi
VBA
0 vote209 views1 answer
Excel vba existence of a file
VBA
0 vote227 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote235 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote227 views1 answer
Excel vba formatconditions positive
VBA
0 vote227 views1 answer
Write listbox to text file vb.net
VBA
0 vote195 views1 answer
Excel vba linter
VBA