excel vba how to reset usedrange

The solution for “excel vba how to reset usedrange” can be found here. The following code will assist you in solving the problem.

Sub ResetUsedRange(ws As Worksheet)
If ws.UsedRange.Rows.Count Then ws.UsedRange.Calculate
End Sub
‘——————————————————————

‘Call the above procedure like so:
ResetUsedRange Sheet1

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts