Thanks for the quick answer :-)

I would really prefer to get such answers from the documentation instead of
the NG. I find the VBA help/documentation a bit confusing. The returned
object is important to me, because i have heard that performance might
suffer badly if i just used object.

Anyway i found that i should use a collection instead to save my ABC
objects. I really don't know if that is smart, when thinking of performance,
because the object is determined in run-time.

Mark

"Jan Karel Pieterse" wrote in message
...
Hi Mark,

With Worksheets("TABLE").Range("a1").EntireColumn
set ABC = .Find(.....)
end with

What is ABC?! The reason i ask is because i want to store ABC in an
array
for later use. I have looked in the documentation under Find and it says
NOTHING about the type of ABC.


ABC will be a Range object (a single cell in this case).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com