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

6 votes245 views1 answer
Excel vba get the path of current workbook
VBA
1 vote234 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
22 votes557 views1 answer
Xl vba check for folder
VBA
3 votes232 views1 answer
Excel vba read registry key value
VBA
0 vote232 views1 answer
Vba add spaces
VBA
0 vote230 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote257 views1 answer
For each item in folder outlook vba
VBA
0 vote272 views1 answer
Vba cell all borders
VBA
0 vote235 views1 answer
Excel vba disable keyboard input
VBA
0 vote240 views1 answer
Excel vba hide gridlines
VBA