I think she was Patrick!
Paul

On Nov 2, 1:25*pm, joel wrote:
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"MicrosoftOffice Help</a>