Hey guys,
I have a code that Prints screen:
How do i paste this in a worksheet using a code in VBA?![]()
Application.SendKeys "(%{1068})" DoEvents
Thanks!
Hey guys,
I have a code that Prints screen:
How do i paste this in a worksheet using a code in VBA?![]()
Application.SendKeys "(%{1068})" DoEvents
Thanks!
Just add this line at the end
![]()
SendKeys "^v"
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
but what if i need the exact worksheet?
Use the below code to open that worksheet, then paste and close that.
![]()
Workbooks.Open Filename:="Address of your workbook\Name of your workbook" Sheets("Your desired sheet").Select Range("Your desired range").Select SendKeys "^v" ActiveWindow.Close
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks