If Cell.Value= "test" Fill Range with colour

[rename]

Hi, I've named range C1:X1 as RANGE
What i need is excel to seach the range for values equals to test and then shade the cell from the active cell to the cell 10 rows below. Currently my code is like this :

Please Login or Register  to view this content.

Anyone know what should I replace with the Range? Thanks in advance. I'm using excel 2003 by the way.

[HaHoBe]

hHi, rename,

what about using Resize for that?

Please Login or Register  to view this content.

And I would use a Variabe called RANGE in VBA.

Ciao,
Holger

[rename]

Works perfect. Thanks