<div>
Range(&quot;A1:L200&quot;).select<br />
<br />
Range(&quot;A2:L2000&quot;).select
</div>


Range("A1:L200").select

Range("A2:L2000").select

<div>
Option 2 is what I was looking for thanks
</div>


Option 2 is what I was looking for thanks

<div>
sorry Saqib but,<br />
<br />
If I want to select from A2 to L500 or A2 to L1000 etc this does not work it always selects from A1.<br />
<br />
Can you assist
</div>


sorry Saqib but,

If I want to select from A2 to L500 or A2 to L1000 etc this does not work it always selects from A1.

Can you assist

<div>
Range(&quot;A1&quot;).currentregion.<wbr />offset(1).<wbr />resize(-1,<wbr />12).select<wbr />
</div>


Range("A1").currentregion.offset(1).resize(-1,12).select

<div>
tried that but it did not work.
</div>


<div>
Try this<br />
<br />
Range(&quot;A1&quot;).currentregion.<wbr />offset(1).<wbr />resize(Ran<wbr />ge(&quot;A1&quot;).c<wbr />urrentregi<wbr />on.rows.co<wbr />unt-1,12).<wbr />select
</div>


Try this

Range("A1").currentregion.offset(1).resize(Range("A1").currentregion.rows.count-1,12).select

<div>
<div class="content wysiwyg-content">
I need to select a range from A-L but the range on the sheet is A - AQ <br />
<br />
So lets say I want to select A1 to L200 or A2 to L2000<br />
<br />
Could an Expert provide me with the VBA code to do this please<br />
<br />
Thanks
</div>
</div>


I need to select a range from A-L but the range on the sheet is A - AQ 

So lets say I want to select A1 to L200 or A2 to L2000

Could an Expert provide me with the VBA code to do this please

Thanks

select a range within a bigger range

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

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.