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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Bobby J" <Bobby wrote in message
...
I'm writing a macro to cut and paste data to the next blank row in an
Excel
file. Any ideas?