Runtime error 91 Objecr Variable of With block variable not set

[s_ali_hassan]

Hi,

I'm hoping someone here can help with an irritating problem i am currently having in my macro.

I am trying to search for a value in a worksheet but i keep getting the 'Object variable or With block variable not set' error on the following line of code:

......
Cells.Find("08:00", SearchDirection:=xlNext).Activate
.......

i have no idea why i am getting this error.

Anyone have any ideas how i can get around this.

Thanks!