Two things - in the below code . I have just recorded a macro to get this .
1, Is there a neater why to do this and
2, The start cell is static but the to cell can vary (j2 static. j50 can vary ) is there a way to acheive this with out having to alter the code every time...