Run-time error '424' Object Required

Hello everyone

I'd like to say thanks in advance for any help.

In my project I have a search function that has to search a row for a number and if the number is found, it should return all data written on the spreadsheet row to respective text and comboboxes on the userform, but I recieve a run-time error 424 object required error and the line that gets highlighted is *For each c in DataBase.range("C:C").cells* and I don't know why. Here is my piece of code below. DataBase is the name of the spreadsheet which must be searched and the searched numbers are always in column C. If a different approach can be used please help me with them. I hope I was clear enough.

Please Login or Register  to view this content.

zbor I apologize for that...I thought using [code] before and after the code would work...I am still new so am really sorry.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Yea, what Norie said

Try Sheets("Database").