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 vote231 views1 answer
Change whcih control a user has selected vb
VBA
0 vote241 views1 answer
Vba check if class implements interface
VBA
0 vote220 views1 answer
Vba file size
VBA
5 votes251 views1 answer
Excel-vba get integer high byte
VBA
0 vote225 views1 answer
Vba add shape oval
VBA
0 vote245 views1 answer
Vba dropdown event
VBA
0 vote302 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote225 views1 answer
Excel VBA web scraping
VBA
1 vote256 views1 answer
Sort using vba
VBA
1 vote246 views1 answer
Excel vba get column number from column name
VBA