With Worksheets("sheet1")
With .UsedRange.Font
.ColorIndex = 0
.Bold = False
End With
For i = 1 To Len(.Range("a100"))
brr(i) = Mid(.Range("a100"), i, 1)
Next
r = .Cells(.Rows.Count, 16).End(xlUp).Row
c = .Cells(7, .Columns.Count).End(xlToLeft).Column
Arr = .Range("h7").Resize(r - 6, c - 14)
End With