Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

How do I copy to the clipboard in Excel/VBA?

I basically want to replicate pressing Ctrl-C to copy the entire active worksheet
0
wordswithfriends
Asked:
wordswithfriends
1 Solution
 
SiddharthRoutCommented:
if you want to make a copy of the sheet then use

Activesheet.Copy

If you want to copy the contents of Sheet then use this

Activesheet.Cells.Copy

Sid
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now