B
Bobby J
I'm writing a macro to cut and paste data to the next blank row in an Excel
file. Any ideas?
file. Any ideas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
R
Rugby Stud
D
Don Guillett
Depends of what you want. No difference IF no blanks
nextblankrow=cells(activecell.row,"a").end(xldown).row+1
lastblankrow=cells(rows.count,"a").end(xlup).row+1
nextblankrow=cells(activecell.row,"a").end(xldown).row+1
lastblankrow=cells(rows.count,"a").end(xlup).row+1
R
Rakesh Sharma
Use this
Range("A1").end(xldown).offset(1,0).select
Activesheet.paste
Regards
Rakesh