I need to find the first blank cell, but ignore A1 and A2 (these are reserved for other data that may not be entered yet). So the first cell available would be A3, even if the entire sheet was blank. Okay, this is the what I have
Sheets("sheet1").Range("A2003").End(xlUp).Offset(1,0).Select
How do I get it to stop trying to set A2 as active instead of A3 when the sheet is blank?
This is what I am using to input the information into several different columns in the same row found above.
Range("A3").Value = txtName.Value
Range("A4").Value = txtQty.Value
So how do I modify the range to use the active row found in the first part?
Sheets("sheet1").Range("A2003").End(xlUp).Offset(1,0).Select
How do I get it to stop trying to set A2 as active instead of A3 when the sheet is blank?
This is what I am using to input the information into several different columns in the same row found above.
Range("A3").Value = txtName.Value
Range("A4").Value = txtQty.Value
So how do I modify the range to use the active row found in the first part?