Matrix Help

Purely as a heads up (given resolved) given changes made in 2007 it's now best to use Rows.Count as opposed to 65536:

eg this:

For N = Cells(Rows.Count, 1).End(xlUp).Row To 3 Step -1

as opposed to this:

For N = Cells(65536, 1).End(xlUp).Row To 3 Step -1

This is purely down to the fact that 2007 has 1 million plus rows and thus you can not guarantee 100% of the time that the 65536 method will work pending version etc.... the Rows.Count method is essentially failsafe
(the same is true re: Columns.Count etc...)