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)
|