PDA

View Full Version : VBA Set cell value under last row



winstonhuxle
07-29-2013, 12:40 AM
Hello, I need to set a cell value in column A, under last row with data. Could you help please? Thanks

patel
07-29-2013, 02:16 AM
LR = Cells(Rows.Count, "A").End(xlUp).Row+1
range("A" & LR).value = yourvalue

winstonhuxle
07-29-2013, 05:24 AM
Perfect. Thanks