Paul,

I suppose we have to agree on the definition of "works."

I was looking at this with "delete rows if the cell in the first column = $" as the sole condition. Where = "$" and = "$ paragraph mark" are two conditions. Mine works with the sole condition "$", yours works with both conditions and works perfectly if that is the goal. Neither works as written for the third condition "$ "

Still it is a clever technique and thanks for sharing.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/