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;}