Help with simple looping program

Stephen wrote:
> I'm a little rusty with my VBA, so please forgive any obvious errors here.
> What I'm trying to do is quite simple - I have a table with 17 columns
> (B2-R2), and 126 rows (B2-B128). Within each row, there is one (and only one)
> "X". I want the macro to look through each row, find the X, then output the
> number of the column containing the "X" into a cell at the end of each row.
>
> Ideally, I'd want a program that could handle multiple "X"'s in each row and
> give me the column number of each of them, but I'd be happy with just finding
> the single "X" for the moment.
>
You might try using the MATCH Function instead. If You enter this
formula in cells S2:S128 it should return the associated column number
for you...=MATCH("x",B2:R2)

Sweet! Thanks!

"Mark" wrote:

>
> Stephen wrote:
> > I'm a little rusty with my VBA, so please forgive any obvious errors here.
> > What I'm trying to do is quite simple - I have a table with 17 columns
> > (B2-R2), and 126 rows (B2-B128). Within each row, there is one (and only one)
> > "X". I want the macro to look through each row, find the X, then output the
> > number of the column containing the "X" into a cell at the end of each row.
> >
> > Ideally, I'd want a program that could handle multiple "X"'s in each row and
> > give me the column number of each of them, but I'd be happy with just finding
> > the single "X" for the moment.
> >
> You might try using the MATCH Function instead. If You enter this
> formula in cells S2:S128 it should return the associated column number
> for you...=MATCH("x",B2:R2)
>
>