Run time error 424

[rinijg]

Hi, I was trying to run the a code for which" run time error 424, object required" error occured. While debugging i found that the error is in Set rsearch line...
Dim rSearch As Range 'range to search
Worksheets("database").Activate
Set rSearch = database.Range("a6", Range("a65536").End(xlUp))

Could you please tell me what to do to clear that error?
Thanks a lot <!-- google_ad_section_end --><!-- / message -->

 

[Comfy]

It should work.

Just double check spelling of sheet names etc.

I don't know what else to suggest.