Quote Originally Posted by TnTinMN View Post
I'm glad you got that resolved. Now you know that you need to do some error checking when working with user prepared data files.

Assuming you left that test code in,

Code:
oXLSheet.Cells(nextRow, 1).value = something
Also, remove the "Stop" statement and flush out some error handling to put in the if statement. Have fun.
Yeah.. stupid me really :L

I have:
Code:
        Dim maxRow As Int32 = oXLSheet.Rows.Count
        Dim nextRow As Int32 = oXLSheet.Range("A1").End(Excel.XlDirection.xlDown).Row + 1



        oXLSheet.Range("A" & CStr(oXLSheet.Range("A1").End(Excel.XlDirection.xlDown).Row + 1)).Select()
But what do I reference in this bit of code to start editing the next empty row, then a custom coloum. Ill try and Pseudocode it.

Code:
 
  If CheckBox1.Checked = True Then
  next clear row + column 2 . text = " I know what Pseudocode means (go me) "