How to select a row using contents of a cell

I am looking to select entire rows (Using code to go into a macro) based on partial contents of a cell. In the attached spreadsheet example I need to select the highlighted area. This is based on the first 4 characters in column A. i.e. the range is column A with the characters AB11 TO AB92. I have been asssuming that I need to use the "MID" function in some way but have failed miserably with each attempt I have made with creating the code (Probaly due to my lack of VBA skills and understanding of the MID function).
If anyone could give some pointers it would be appreciated.

(P.S. I asked a similar question in a different thread but over complicated it by putting in the next stage. I marked that thread as "SOLVED" and put in a comment to say I was going to start a new thread. Please advise if that is the correct way of handling it or should I have done it another way i.e. ask a moderator to close/delete the thread etc)

Where and how do you define the values to be selected? Are there always two? Or could there be three, four, whatever?

If there are two values, would you want everything that is alphabetically/numerically within the range?

Regards

Values the selection is based on are always in column A and are always the 1st 4 digits (2 Letters and 2 Numbers). Basically they are the Aisle letters and the bay numbers in a warehouse (the last 3 digits are relate to shelf height and position and are irrelevant to the selection) and yes I need everything alphabetically then numerically in that selected range.
They always run in that order if that is any help.
If you mean the number of columns in the rows the various spreadsheets the macro will be used on is a maximum of 12.

Thanks Alf. I wasn't thinkinking straight. I was over complicating it by thinking of merging the functions together under a range statement and over-looked just putting in a greater than/less than statement. I'll play around with the proper workbook tomorrow but can't see any reason why it won't work once I change the appropiate references so all solved. Thanks again