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 vote136 views1 answer
Vba remove last vbcrlf
VBA
0 vote133 views4 answers
Jwt token vb.net validation
VBA
1 vote140 views1 answer
Excel vba get column number from column name
VBA
1 vote135 views1 answer
Add rows to datagridview vb.net
VBA
0 vote127 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote120 views1 answer
Vba line feed
VBA
0 vote119 views1 answer
Add items to combobox vb.net
VBA
1 vote141 views1 answer
Vba format string as cash
VBA
4 votes132 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote124 views1 answer
Vba leading zeros in string
VBA