select a range within a bigger range

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
JagwarmanAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Or maybe you are looking for something like

Range("A1").currentregion.resize(,12).select
0
 
Saqib Husain, SyedEngineerCommented:
Range("A1:L200").select

Range("A2:L2000").select
0
 
JagwarmanAuthor Commented:
Option 2 is what I was looking for thanks
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 
JagwarmanAuthor Commented:
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
0
 
Saqib Husain, SyedEngineerCommented:
Range("A1").currentregion.offset(1).resize(-1,12).select
0
 
JagwarmanAuthor Commented:
tried that but it did not work.
0
 
Saqib Husain, SyedEngineerCommented:
Try this

Range("A1").currentregion.offset(1).resize(Range("A1").currentregion.rows.count-1,12).select
0
 
JagwarmanAuthor Commented:
perfect thanks
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.

All Courses

From novice to tech pro — start learning today.