Improve company productivity with a Business Account.Sign Up

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

Copy a range of cells

Could an expert provide me with a piece of VBA code that will select a range of cells and copy it.

i.e. the range will always differ so it could be from A1 to S1000 or A1 to AC10000 or A1 to BB100 etc

It will alwys start at A1

Thanks
0
Jagwarman
Asked:
Jagwarman
1 Solution
 
Rory ArchibaldCommented:
How should the code know what to copy?
0
 
Saqib Husain, SyedEngineerCommented:
Range("A1").currentregion.copy
0
 
JagwarmanAuthor Commented:
brilliant. Easy when you know how.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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