Run time error 424

E

emmanuel

Joined
May 12, 2011
Messages
20
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Case not working - Why? 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA Marco to Change Display Units Not Working 2
Run-time Error '1004' 1
Run-Time Error 1
(xlUp) problems then use in non excel 0
Excel Form HELP 3
Another For each headache I get 6

Top