I have a sheet with a named range CODES_RANGE=Sheet1!$A:$A. Some CODES_RANGE rows has a value "x". I need to get in a range variable (in VBA) only the rows with "x" value.

I know that I can do a for each statement, but in this case the delay time will be heavy because a lot of rows.

Is there any method or instruction that I can use to avoid an iterate cycle?

Thanks.

0 Answers