<div>
How should the code know what to copy?
</div>


<div>
brilliant. Easy when you know how.
</div>


<div>
<div class="content wysiwyg-content">
Could an expert provide me with a piece of VBA code that will select a range of cells and copy it.<br />
<br />
i.e. the range will always differ so it could be from A1 to S1000 or A1 to AC10000 or A1 to BB100 etc<br />
<br />
It will alwys start at A1<br />
<br />
Thanks
</div>
</div>


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

Copy a range of cells

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.