"BigDave" wrote in
message ...

Question1: .screenupdating = false and xlCalculationManual - are these
necessary. What would happen if I took those out?

It would be slower and you would see lots of screen flashing.

Question2: this proceedure is activated with a button on Sheet2.
After the blanks are deleted, I need to copy A2:M21 on sheet "ws1", but
"ws1" is (1) hidden and (2) the workbook is protected. The code above
does what its supposed to do, but in proceedure the clipboard is
getting wiped out and I can't paste (into another, seperate workbook)
what I copied. Can I copy a range on a hidden sheet in a protected
workbook? If so, how?

Yeah, hidden and protected is okay


Worksheets("ws1").Range("A2:M21").Copy Worksheets("Sheet2").Range("A2")

Qestion3: When this proceedure ends, incell functions I have on Sheet2
cycle through again. Here is the function:

Don't understand this one.