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 vote280 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote282 views1 answer
Vba shape transparent
VBA
0 vote256 views1 answer
Vba select file in folder
VBA
0 vote279 views1 answer
Label de tableau dans des label.text en VBA
VBA
5 votes318 views1 answer
Excel vba right word from Long Integer
VBA
1 vote266 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
31 votes385 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote304 views1 answer
Vba variable number of arguments
VBA
8 votes326 views1 answer
Excel vba determine number of elements in a 1D array
VBA
1 vote278 views1 answer
Excel vba last row of range
VBA