Question : excel vba how to reset usedrange
Answered by : daniel-ferry
Sub ResetUsedRange(ws As Worksheet) If ws.UsedRange.Rows.Count Then ws.UsedRange.Calculate
End Sub
'------------------------------------------------------------------
'Call the above procedure like so:
ResetUsedRange Sheet1Source : http://academy.excelhero.com/ | Last Update : Sat, 04 Apr 20