You don't need the copy, you can assign the value directly like below
Cells(Target.Row, 4) = Range("j1").value
You don't need the copy, you can assign the value directly like below
Cells(Target.Row, 4) = Range("j1").value
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks