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 vote377 views1 answer
Vbnet find highest value in chart
VBA
0 vote367 views1 answer
Thread sleep vb
VBA
0 vote411 views1 answer
Vbs run with cscript
VBA
0 vote382 views1 answer
Prive sub enter clicked vb
VBA
0 vote403 views1 answer
Vba remove the first character of string
VBA
0 vote383 views1 answer
Vba registry settings
VBA
0 vote370 views1 answer
Enable macros on opening workbook vba
VBA
0 vote418 views1 answer
Filesystemobject vba reference
VBA
1 vote368 views1 answer
Excel vba force recalculation
VBA
0 vote344 views1 answer
Vba select file in folder
VBA