hello
i want to copy a range of sheets("name").range("a4:a100) and paste on another workbook sheets("name").range("a4:a100"), but one by one
e.g
sheets("name").range("A4:A100).copy
and paste new workbook with
sheets("name").range("A4:A100")
first paste a4
secondly paste a5
third paste a6
forth paste a7
....paste a100
thanx
Bookmarks