default last line

Posted by michael on August 22, 2001 12:40 PM

Im wondering if this can or cannot be done

im scanning barcodes into excel, a customer number will appear and return to the next line

what im trying to do is default 'done!' to the last line

so if i do want to add another line, excel will always (no matter the number on entries) have the word 'done!' on the last line

Posted by Tom Urtis on August 22, 2001 5:05 PM

It sounds like you want the word "Done" to appear in the next available row of a dynamic range. Assuming you want it in column A, you could try adding the following code:

Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveCell.FormulaR1C1 = "Done"

HTH

Tom Urtis