Tom,

I'm sorry if I was not clear. What I wanted to do is, let's say, I hav
several data on several columns but on a single row only, ie. A7, B7
C7, D7, E7, etc. Now, I would like to find a data along this row an
once found, get the column name/number so that I can use it later on m
script. Do I have to iterate through all the column, or can I do i
using the FIND command?

Thanks,
Sinobat

--
Message posted from http://www.ExcelForum.com