Sorry for my poor explanation. I am not trying to be obscure. The code in post 11 doesn't work unless the active cell is A1. My screenshot is missing an explanation I wrote and omitted, if you look at the highlighted cell J1 you will see the array of cells all around are still there and this shot was taken just after I ran the code in post 11, you will notice the diagonal starts at an offset along the same row as J1 equal to the distance J1 is from A1. Otherwise it works fine. Hope this is clearer.
Bookmarks