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

3 votes203 views1 answer
Extract the nth word from a text string
VBA
0 vote174 views1 answer
Excel vba concatenate range
VBA
1 vote191 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote196 views1 answer
Excel vba remove formatting from cell
VBA
0 vote212 views1 answer
Vba sheet hide unhide
VBA
0 vote222 views1 answer
Vbs run with cscript
VBA
2 votes193 views1 answer
Excel vba date to string conversion
VBA
0 vote205 views1 answer
Delete rows in excel vba code
VBA
3 votes206 views2 answers
Excel "vba" match last value
VBA
0 vote205 views1 answer
Vb ternary
VBA