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

1 vote320 views1 answer
Excel vba get column name from number
VBA
1 vote342 views1 answer
Excel vba first row in range
VBA
2 votes319 views1 answer
Vba uppercase first letter of each word
VBA
0 vote352 views1 answer
Vbscript remove spaces from string
VBA
0 vote355 views1 answer
How to enter Vbox manage commands
VBA
31 votes481 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote330 views1 answer
Excel vba disable keyboard input
VBA
1 vote371 views1 answer
Random number generator vb.net
VBA
0 vote344 views1 answer
Excel vba remove formatting from cell
VBA
18 votes533 views2 answers
Vba make word from bytes
VBA