Cell = Range("A1") Type mismatch

I'm trying to clear all cells on a sheet that are not in the Range between A1:F1

This is what my code looks like:

Please Login or Register  to view this content.

The idea was to go through each cell in WorkRange (which is every cell defined by the .UsedRange method -- which I'm assuming just means every non-empty cell in the sheet).

If the cell is in the range I don't want deleted then nothing happens, else clear the cell.

On the line "If Cell = Range("A1") Or Range("B1")...." It yields a Type Mismatch error.

Thoughts?

Thanks!

Please Login or Register  to view this content.

Thank you!
That worked fine, I didn't realize I had to be so explicit in the structure.