Excel 2000 Find without select VBA

[Matt.]

I'm trying to create a small function that returns the column number of the
Result of a Find. But I don't want to Activate or Select the result of the
Find. Is there a way to do this? Google search through Groups and Web
Pages was vague to say the least.

cheers,
Matt.

 

[Don Guillett]

how about something like
x=yourfind.column

 

[Chip Pearson]

Matt,

Try something like

Dim ColNum As Integer
ColNum = Cells.Find(what:="whatever").Column


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Matt.]

Thank you Chip!

Exactly what I needed!

cheers,
Matt.