View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] prasanna.janardhana@gmail.com is offline
external usenet poster
 
Posts: 3
Default To return the column number of a string

Hello All,
I am pretty new to Excel Macros. I was writing a code and stuck up
with this problem.
I want to write the code to return the column number of a particular
string.
Like, I have "VET" string in one of the cells, A20

My code has to return to the column number 1 for the string "VET"

Please help,
Thanks,
Prasanna.