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 vote251 views2 answers
Vba string length
VBA
22 votes313 views1 answer
Excelvba check for directory
VBA
0 vote252 views1 answer
Excel named range sum
VBA
8 votes251 views1 answer
Excel vba determine number of elements in a 1D array
VBA
3 votes277 views1 answer
Vba continue for each loop
VBA
0 vote245 views1 answer
Vbnet chart make 0 gridline line different color
VBA
25 votes325 views3 answers
String to date vb
VBA
0 vote249 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote228 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote251 views1 answer
Send text to clipboard vb.net
VBA