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 vote134 views1 answer
How to sort datagridview in vb.net
VBA
0 vote203 views1 answer
VBA Sort RossetaCode
VBA
0 vote182 views1 answer
Excel vba scroll to cell
VBA
6 votes203 views1 answer
Excel vba isalpha
VBA
0 vote195 views1 answer
Excel vba textbox forecolor disabled
VBA
2 votes138 views2 answers
Vba exit loop
VBA
4 votes180 views1 answer
Excel vba determine number of elements in an array
VBA
3 votes177 views1 answer
Vba folderexists
VBA
0 vote192 views1 answer
Putting marquee in vb.net
VBA
0 vote181 views1 answer
Visual basic msdos
VBA