I have tried this a couple of ways and both give error 1004
For iCo l = iLow To iHigh
ActiveWorkbook.Sheets("Main").Range(Cells(iReadyRo w, iCol)).Value = "No"
Next


For iCol = iLow To iHigh
ActiveWorkbook.Sheets("Main").Range(Cells(iReadyRo w, iCol)).Select
Selection.Value = "No"
Next

Both fail on the ActiveWorkbook line. Any idea what I am doing wrong?

And - maybe there is a more elegant way to reset a range to a value other
than cell by cell. I guess I could have a range of the same size hidden
somewhere with "No" in every cell and just copy it over the top.

TIA
-- Len