how to program from excel to enter information in the next blank cell

k_babb · September 11th, 2011, 01:54 PM

can someone help with my code i am new to c# and programming but would like to change my code rather then write to A2 to look at the active sheet and find the next free cell in column A and write to that cell here is the code i am using

Code:

 object company = sheet.Application.InputBox("Enter Company Number", "Company Number");
            object comments = sheet.Application.InputBox("Enter Comment's", "Comments");
            sheet.get_Range("A2", misValue).Formula = date.ToString(format);
            sheet.get_Range("b2", misValue).Formula = currenttime.Text;
            sheet.get_Range("c2", misValue).Formula = currenttime.Text;
            sheet.get_Range("d2", misValue).Formula = company;
            sheet.get_Range("e2", misValue).Formula = comments;
            Start.BackColor = Color.Green;}