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 votes166 views1 answer
Vba array contains
VBA
0 vote178 views1 answer
Excel vba show developer tab
VBA
5 votes177 views1 answer
Xlvba double quotes in string literal
VBA
0 vote174 views1 answer
Arq linux
VBA
0 vote178 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote172 views1 answer
Change whcih control a user has selected vb
VBA
0 vote184 views1 answer
Make your computer talk vbscript
VBA
31 votes234 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote179 views1 answer
Vba word pdf table to excel
VBA
0 vote157 views1 answer
Vba copy paste value only
VBA