Option ExplicitSub MakeExceptions()Dim oCells As RangeDim pastePt As RangeDim arrAllCells As VariantDim lCounter As Long With Application .Calculation = xlCalculationManual .ScreenUpdating = False End With arrAllCells = Range("AC6:AC756") If VBA.IsArray(arrAllCells) Then For lCounter = LBound(arrAllCells) To UBound(arrAllCells) If arrAllCells(lCounter, 1) = 1 Then If oCells Is Nothing Then Set oCells = ActiveSheet.Cells(lCounter + 5, 1).EntireRow Else Set oCells = Application.Union(oCells, ActiveSheet.Cells(lCounter + 5, 1).EntireRow) End If End If Next End If If Not oCells Is Nothing Then oCells.Copy Windows("Exceptions.xls").Activate Set pastePt = [TopA].End(xlDown).Offset(1, 0) pastePt.PasteSpecial Paste:=xlPasteAll oCells.Delete Shift:=xlUp End If With Application .Calculation = xlCalculationAutomatic .CutCopyMode = False .ScreenUpdating = True End WithEnd Sub

"Dim cstr as String..." I should have noticed that. :-) Fernando and Brad, yours look promising, I hope I actually do manage to check this out tomorrow. As I've been asking several other people tonight, pls forgive me for losing track of this question!

Man, where have I been! Brad and Fernando, yours both work faster than mine, thank you. Fernando, although it wasn't critical yours produced a REF error for some reason on one of the copied columns, which is why I gave Brad the extra points.

Ssaqibh, I tinkered with yours a lot but I just couldn't get it to work. Probably my ineptitude, sorry.\\Thanks,
John

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards.
Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…

The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.