selects only the cells that starts with a specific value 1

[eon5]

Hi,

I have do until loops that is deleting cells that contains the code CUSF00110.

If sheet2.range("a"&x).value = "CUSF00110" then

It works perfectly but more codes starting with "CUS" is getting generated in the data base. Thus the do until loops must delete not only that specific code "CUSF00110" but all codes starting with "CUS", will be a safe bet.

any advice?

 

[ettienne]

If Left(sheet2.range("a"&x).value,3) = "CUS" then

 

[SkipVought]

Hi,

Also...

If sheet2.cells(x, "A").value Like  "CUS*" then

[code]


Skip,
[sub]
[glasses]Just traded in my old subtlety...
[b]for a NUANCE![/b][tongue][/sub]