search in sheet1 for particular string and copy in another sheet

Hi,

i have to make a macro to search in sheet1 for particular string and copy in another sheet .

the below code is not working .

raw input is attached .kindly help .

Please Login or Register  to view this content.

.....................................

I would entirely get rid of your macro, as Select+Activate is bad habit. Try this one:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Hi there Paul
You used bottomA variable that is not declared nor initialized.
Also you declared lastrow as Integer even though excel has many more rows that Integer variable type can hold.
Also instead of

Please Login or Register  to view this content.

I thing that more appropriate would be

Please Login or Register  to view this content.

that way rng could contain the searched text but not only.

Best wishes,
Bogdan

Hi Sir,

i have tried with your suggestions . But still not successful . Please suggest .

i have tried with below code.

Please Login or Register  to view this content.

Hello Vikas,

A slight addition to the code should help:-

Please Login or Register  to view this content.

The additional asterisk (in red font above) should be all that you need.

Also, you have placed the code into the Sheet1 module. This is not an event code so it needs to be placed in a standard module and assigned to a button.

I hope that this helps.

Cheerio,
vcoolio.