<?xml version="1.0" encoding="windows-1252"?>
<node id="316861" title="Re: Re: Using Win32::OLE and Excel - Tips and Tricks" created="2003-12-24 10:32:04" updated="2005-07-07 15:02:33">
<type id="11">
note</type>
<author id="315379">
maa</author>
<data>
<field name="doctext">
Hi,&lt;br/&gt;
If you look at the VB from a macro it is... &lt;code&gt;Cells(r,c).Find(...).Activate&lt;/code&gt; which tells you that the &lt;code&gt;$Sheet-&gt;Range("A1:B10")-&gt;Find()&lt;/code&gt; operation is &lt;b&gt;returning&lt;/b&gt; something... that you can &amp;quot;&lt;code&gt;-&gt;Activate&lt;/code&gt;&amp;quot; it means that it is a Range object you're getting back... so you can try&lt;br&gt;
&lt;code&gt;my $Range=$Sheet-&gt;Range("A1:B10")-&gt;Find("bob");&lt;/code&gt;
&lt;p&gt;HTH - Mark&lt;/p&gt;
</field>
<field name="root_node">
153486</field>
<field name="parent_node">
316857</field>
</data>
</node>
