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 vote388 views1 answer
Vba boolean to string
VBA
0 vote341 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote350 views1 answer
Vbnet check if string is only numbers
VBA
0 vote338 views1 answer
Refresh token em vb net
VBA
0 vote394 views1 answer
Vba is integer
VBA
0 vote388 views1 answer
Vba remove the first character of string
VBA
0 vote370 views1 answer
Excel last used row
VBA
0 vote350 views1 answer
String contins in vba
VBA
0 vote364 views1 answer
Loop through all text boxes in a form vb
VBA
22 votes574 views1 answer
Xl vba check for folder
VBA