excel vba - Copy data upto last used Row of a specific column -

excel vba - Copy data upto last used Row of a specific column -

i using code lastly used rows-

rowno=objexcel.activeworkbook.sheets(1).usedrange.rows.count

now, want re-create info of specific column upto lastly row used.

//what write in below code utilize rowno //

set source=objexcel.activeworkbook.sheets(1).column("g")

source.copy

that's wrong way find lastly row. see link on how find lastly row.

once have found lastly row utilize code copy

ws.range("g1:g" & rowno).copy

where ws worksheet object.

excel-vba vbscript