Remove Cells from a Range Object

[chris.c]

Hey all,

I am attempting to remove certain cells from a range that I have previously defined. I've come up with a way to do this but I'm wondering if there's an easier way. Here is what I have:

Please Login or Register  to view this content.

Like I said, this works but it seems like there should be a more efficient way. Any thoughts?

[Jacc]

A discussion here:
http://www.dailydoseofexcel.com/arch...-and-subtract/

[chris.c]

Alright, thanks.