eAlchemist
Technical User
OK... I can't figure this out! I get very different results when I run this vs. when I step through this. When I run it, all the array formulas are written-over, but when I step through, the If/Then in the middle of this loop works appropriately. Can anyone see how this could be?
Chris
For Each Sheet In ActiveWorkbook.Sheets
If Sheet.Name <> "Summary" And Sheet.Name <> "ArrayFormulas" And Sheet.Name <> "RawData" And Sheet.Name <> "TOTAL" Then
For Each Cell In Sheet.UsedRange
If Cell.HasArray Then
RowLabel = "C" & Cell.Row
If Range(RowLabel).Value <> "Act" And Range(RowLabel).Value <> "Brand Act." Then
Cell = Cell.Value
End If
End If
Next Cell
End If
Next Sheet
Chris
For Each Sheet In ActiveWorkbook.Sheets
If Sheet.Name <> "Summary" And Sheet.Name <> "ArrayFormulas" And Sheet.Name <> "RawData" And Sheet.Name <> "TOTAL" Then
For Each Cell In Sheet.UsedRange
If Cell.HasArray Then
RowLabel = "C" & Cell.Row
If Range(RowLabel).Value <> "Act" And Range(RowLabel).Value <> "Brand Act." Then
Cell = Cell.Value
End If
End If
Next Cell
End If
Next Sheet