It performs the macro outside of the range, I want to keep the macro in a
specific area and not find 1's and 2's in other parts of the worksheet.

Bob Phillips wrote:
Trouble in what way? It errors, doesn't do what you want?

What is it supposed to be doing?

I am having trouble with getting this to pass through the range of
"DataWithOnes". Not sure how to do this, can anyone see why?
[quoted text clipped - 34 lines]

End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200801/1