Thread: Search Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Moises Moises is offline
external usenet poster
 
Posts: 22
Default Search Formula

I have text data in Column A (from A1 to A300), I would like to search each
cell in column A in order to get the position number of the character *
and the result in B cells, I am trying with the following code, but I have
problems in coding the A column :

For i=1 to 300
Cells(i,2).Formula="=Search("*","A",i,1)"
Next

Thanks for your help
--
Moises