Horje
excel vba how to reset usedrange Code Example
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



Vb

Related
vba file from path Code Example vba file from path Code Example
excel vba determine number of elements in a 2D array Code Example excel vba determine number of elements in a 2D array Code Example
excel vba recursive example factorial function Code Example excel vba recursive example factorial function Code Example
excel vba extract file name Code Example excel vba extract file name Code Example
excel vba determine number of elements in a 1D array Code Example excel vba determine number of elements in a 1D array Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 8



 

Horje