looking for a vba code for a button please help

[pelums1]

I'm trying to select a cell in columns a based on a value in range ("c4").
is there such a code besides the one below? if I use this code for every cell
then the code will be too long and it want work.
it should be a loop code but cant find one.
needs to be from range a1:a2000. Thanks


If Range("a1") = range ("c4") then
Range ("a1") .select
End if

[Special-K]

Maybe this (Im no VBA expert)

Please Login or Register  to view this content.

[HaHoBe]

Hi, pelums1,

you could use Find or Macth (sample code attached) instaed of a loop:

Please Login or Register  to view this content.

I donīt like to loop but anyhow:

Please Login or Register  to view this content.

Ciao,
Holger

[pelums1]

thanks special k it work just the way i wanted it too.