Converting Array to Integers

Hello cporter5,

You are correct about the variable not be initialized. The easiest way is to initialize the variable when the workbook first opens. Copy this code into the ThisWorkbook module.

Private Sub Workbook_Open()
  N = 1
End Sub