Select range till where column AG has "BB" value

[HaroonSid]

hello
i m using below line to get range of data,

Please Login or Register  to view this content.

i want this one get only range according to column AG

i mean
i have data in c10:c100 and ag10:ag50 has a value "BB"

then select the range C10:C50 not C10:C100 which below line will do

Please Login or Register  to view this content.

thanx

[HaHoBe]

Hi, haroon2015,

you would need to make clear if the data is thoroughly "BB" or not.

Maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[TMS]

One way, something like:

Please Login or Register  to view this content.

Regards, TMS

[HaroonSid]

Hello HaHoBe

Range C10:C300 has Names and
Range AG10:AG300 has Value "N", "BB" and "BBB", i want if AG10:AG15 has a value "BB"
then select the range C10:C15

[HaroonSid]

Hello HaHoBe

absolutely perfect as always in first attempt and u better understand what OP wants,

thanx a lot and will add reputation as always i do

[HaHoBe]

Hi, haroon2015,

your post does not fully answer what I want to know. I understand that AG10:Ag15 hold BB but will this item appear later on as well? If not my code should do fine. If yes you should use a loop to determine the first appearance of the item and leave the loop when a different item is found to get the row number to "Select" (whyever you think you need to Select or Activate and what may be proven to be just a waste of time).

Ciao,
Holger