object variable not set

[galaxtor]

hi..i am new at vba
when i did not select the cell with the "hello" inside, i encounter an error that says object variable or with block variable not set. what does it means?

Please Login or Register  to view this content.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

EDIT: Roy's note about xlValues didn't stop my search for "hello", but it may on your sheet. Things happen. Changing to xlValues may be the thing to do.

[royUK]

You search was looking at Formulas, not a a value, I've also changed selection for UsedRange so that it is not necessary to select the range.

Please Login or Register  to view this content.

[D_Rennie]

............................

[galaxtor]

THANK YOU JBeaucaire , royUK, D_Rennie!!!

its working already and i've understand your points =)

[galaxtor]

hello..yst i posted on this issue object variable not set. i've realise there is an error.

i tried JBeaucaire codes..it was working fine..until i selected on the active cell, it prompt me item was not found.

i also tried royUK codes..it could find the info..but when the info is not found, it did not prompt me the error msg but instead it came out the Object variable or with block variable not set..

anyone can help?

so far this is what i did.

Please Login or Register  to view this content.

[royUK]

maybe this amended code will help

Please Login or Register  to view this content.

[romperstomper]

You could shorten things a bit with an array or two:

Please Login or Register  to view this content.

Did you only want the error message if no items are found, or if any of the items are not found?