Hi all,

Need a macro that takes a value from a cell eg B:2 'does something' then posts the answer in B:3 and then does the same for C:2 D:2 to x:2 etc. The' do something' part is a case statement which I know how to do, just don't know how to loop through the cells.

Thanks!