Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Copy a range of cells

Posted on 2013-11-29
3
174 Views
Last Modified: 2013-11-29
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
Comment
Question by:Jagwarman
3 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39685130
How should the code know what to copy?
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39685151
Range("A1").currentregion.copy
0
 

Author Closing Comment

by:Jagwarman
ID: 39685337
brilliant. Easy when you know how.
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Outlook Free & Paid Tools
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question