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 vote265 views1 answer
Vba ternary
VBA
1 vote232 views1 answer
Export datagridview to excel vb.net
VBA
1 vote219 views1 answer
Excel vba last column in range
VBA
0 vote248 views1 answer
How to mount floppy disks in vb.net
VBA
3 votes214 views1 answer
Vba folderexists
VBA
0 vote213 views1 answer
Excel vba milliseconds
VBA
31 votes481 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote217 views1 answer
Do while not vb.net
VBA
0 vote229 views1 answer
String contins in vba
VBA
0 vote243 views1 answer
Delete all controls in an area vb
VBA