I wish to write a macro for excel. The macro would read
the value in R1,C1, if the value is >=1 then the contents
of row 1,(R1,C2...C8) would be copied to a new worksheet
at row 1, if the value is zero it would do nothing but
read the value in R2,C1 and then repeat the "if then"
until eof.

Thanks