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

3 votes337 views1 answer
Excel vba make long from two shorts
VBA
0 vote297 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote287 views1 answer
Excel vba open browser
VBA
0 vote316 views1 answer
Excel vba hide gridlines
VBA
1 vote312 views1 answer
Excel vba force recalculation
VBA
1 vote310 views1 answer
Excel vba compare 2 rows
VBA
0 vote319 views1 answer
Excel vba first working day month
VBA
0 vote334 views1 answer
Sort dictionary by key vba
VBA
0 vote301 views1 answer
Excel vba scroll to cell
VBA
0 vote319 views1 answer
Send text to clipboard vb.net
VBA