Forum Discussion
Solved
paste special in vba not working
Hello excel community hope all of you are doing well i have a concern about paste special, i am doing a file where i will have different sheets created based on states now when i use paste spec...
PasteSpecial selects the range you paste to.
If you use range.Copy Destination:=other_range, that does not happen, so it would be better to use that.
HansVogelaar thank hans, one more question, after everything is copied, in all my new sheets created, i have last row selected, how to deselect it? i tried to put at end of code range("a1").select to select some other thing, but it didnt work, any suggestion?
PasteSpecial selects the range you paste to.
If you use range.Copy Destination:=other_range, that does not happen, so it would be better to use that.
- Thanks Hans, these small things that i like to learn !