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 vote283 views1 answer
Excel vba scroll to cell
VBA
0 vote278 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote280 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote302 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote301 views1 answer
Vba round to 2 decimals
VBA
0 vote317 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote285 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote295 views1 answer
Vba first cell in range
VBA
0 vote289 views1 answer
Select case vba
VBA
0 vote301 views4 answers
How to continue formula in below line in vba code
VBA