VBA remove index cell used

Post date: Sep 23, 2016 7:35:54 PM

Dim sh As Worksheet, x As Long

For Each sh In ActiveWorkbook.Worksheets

x = sh.UsedRange.Rows.Count

Next sh