Sheet1.Range("B" & i + 1).Copy Sheet2.Range("B" & (cellsh2 + 3)).value
This above does not work. "Copy method of Range class failed". Why? What is proper syntax suppose to be?
Thanks.
Sheet1.Range("B" & i + 1).Copy Sheet2.Range("B" & (cellsh2 + 3)).value
This above does not work. "Copy method of Range class failed". Why? What is proper syntax suppose to be?
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks