cut cells and paste to table on separate worksheet/table on button click

Originally Posted by natefarm

One way to find the last data row is

Dim endrw as Long
endrw = Range("A" & rows.count).End(xlup).Row + 1

That's assuming there is always data in column A. If not, use a column where every row will have data.

The "+1" would give the first empty row, not the last data row?