Solved

Copy a range of cells

Posted on 2013-11-29
3
148 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now