Patrick Molloy: I don't think Sheela was refering to the Dim statements.
Sheela was refering to the properties of the VBA Find. That setting
the properties in one Find to (ie xlpart) means that the following Find
statments would also use xlpart not xlwhole. VBA find is unlike other
methods that is doesn't use a default setting, instead it use the last
setting which could also include any time the FIND is used in the
worksheet menu.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149293

<a href="http://www.thecodecage.com">Microsoft Office Help</a>