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