I have a spreadsheet in which I'd like to avoid using hidden columns. Therefore I am looking to use a macro/VBA routine to do a calculation.
If I enter an amount in cell A2, I need a formula to scan a range of alternate cells on the same row (eg. C2, E2, G2, I2), and increment a counter for each cell that *does not* contain an 'x' char.
I then need to use the result of that macro to use in a formula for cell B2. Eg. =100/(result of formula)
Can this be done, and do you want more info?