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 votes277 views1 answer
Excel insert blank row for value change in column
VBA
0 vote276 views1 answer
Vbscript for loop
VBA
1 vote296 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote279 views1 answer
Vba sheet hide unhide
VBA
0 vote249 views1 answer
Enter into cells data grid view
VBA
0 vote269 views1 answer
VB Error Code BC30201
VBA
0 vote264 views1 answer
Vba line feed
VBA
0 vote295 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote262 views1 answer
Vba word pdf table to excel
VBA
0 vote281 views1 answer
Excel vba select multiple shapes
VBA