Answers for "excel vba how to reset usedrange"

VBA
4

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
Posted by: Guest on March-28-2020

Code answers related to "VBA"

Browse Popular Code Answers by Language