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 vote191 views1 answer
Vba count all row
VBA
1 vote170 views2 answers
Vba function return array
VBA
2 votes185 views1 answer
Excel vba check if string entirely alpha
VBA
8 votes332 views1 answer
Vba make a short integer from two bytes
VBA
0 vote183 views1 answer
Remove first character from string vb
VBA
0 vote179 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
3 votes187 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote194 views1 answer
Find if year is leap year vb
VBA
0 vote179 views1 answer
Excel vba hide columns
VBA
0 vote194 views1 answer
Vba variable number of arguments
VBA