Find A Record In Another Sheet With VBA Code

Hi All;

I'm trying to find a specific text in another sheet by using the code below. But it gives me "Type Mismatch" error. Being a beginner on Excel VBA coding, I couldn't figure it out. Any help will be appreciated.

Please Login or Register  to view this content.

Thanks

Originally Posted by TMShucks

Try dumping the "With cst" and "End With". Not sure what you're trying to achieve with that but you don't need it. You've already stored the value in the variable so just loop through the range and test.

Regards, TMS

Thanks a lot for prompt reply.

I've made the change you've proposed but I still get the same error.

I've figured it out. I'm posting here so if anybody will need something similar can use. Mistake was

Please Login or Register  to view this content.

on first range definition line... and;

Please Login or Register  to view this content.

is should be "string" instead.

full working version of the code is below;

Please Login or Register  to view this content.

The scenario I'm using this code is;
There is a sheet named LIST in the workbook where all the customers are listed with their basic information. And all the customers on this list, have their own sheets for other individual data input. When user needs to update any basic information of a customer by returning to the main sheet, in order to find necessary line without an effort, user clicks on a button and code above kicks in.

looks very elegant...
sure I'll give it a try tonight.

thanks a lot again TMS

Regards.