Find code not finding the value - error

[t16turbo]

Hi,

I have some vba that searches for a value in a specified column.

 Range(Columns("A:A").Find("Unplanned Very Likely").Offset(0, 0), _
    Columns("A:A").Find("Unplanned Very Likely Total").Offset(0, 14)).Cut

if that value doesn't exist it returns an error.
"object variable or with block variable not set".

is there a way around this?
thanks in advance,

 

[xlbo]

yup - use an IF statement

very good example in the help files

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question