Find First Instance of Text String in Column

[ScabbyDog]

I want to first the first instance of either 0: or 1: or 2: or 3: in Column A only on Sheet2 and once found copy the cell to Sheet3 D3. These strings can be contained anywhere within a word in Col A.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[ScabbyDog]

Please Login or Register  to view this content.

Regards, TMS

Thanks but I need VBA code. Needs to find the first instance of either 0: or 1: or 2: or 3:
Whatever comes first.

[ScabbyDog]

Will it be something like this? This runs without error but nothing actually copies and pastes despite cell A40 on sheet2 containing the text "14:00:00"

Please Login or Register  to view this content.

[TMS]

14:00:00 will be seen as a time unless the cell is formatted as text. And, if it is a time, it will be a numeric value less than 1 as a time is represented as a fraction of a day. That is 12 pm will be 0.5.

Maybe test .Text rather than .Value:

Please Login or Register  to view this content.

Regards, TMS

[ScabbyDog]

Ah yes, that'd be it! Solved! Thanks all.

[jindon]

Try

Please Login or Register  to view this content.

[TMS]

Jindon's code with some embellishments ...

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Thanks for the rep

[jindon]

ScabbyDog,

You should be very careful when you use Text property.
If the cell width is not wide enough and looks like ####### then it will fail to pick up.