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

2 votes128 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
3 votes123 views1 answer
Excel vba get the workbook full file name with path
VBA
4 votes132 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
5 votes143 views1 answer
Excel-vba get integer high byte
VBA
3 votes131 views1 answer
Vba http request json
VBA
2 votes121 views1 answer
Date format for ms chart vb.net
VBA
0 vote140 views1 answer
Delete all controls in an area vb
VBA
0 vote116 views1 answer
Enter into cells data grid view
VBA
3 votes133 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
1 vote126 views1 answer
How to check is the value enterd is a number or text in vba
VBA