Excel 2000 Find without select VBA
 

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.

Excel 2000 Find without select VBA
 

how about something like
x=yourfind.column

--
Don Guillett
SalesAid Software

"Matt." wrote in message
...
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.

Excel 2000 Find without select VBA
 

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." wrote in message
...
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.

Excel 2000 Find without select VBA
 

Thank you Chip!

Exactly what I needed!

cheers,
Matt.

"Chip Pearson" wrote in message
...
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." wrote in message
...
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.