Code to find a specific word???

Originally Posted by arfanvilla

I require code to find a specific word in a column/sheet to add into my macro.

My current macro:-

Please Login or Register  to view this content.

At the moment the macro will enter the word "*Default*" into the current active cell, then copy the entire contents of Row 2.
The next missing code will need to find the word "*Default*" in the sheet and insert the copied cells.
Then the next missing code again will need to find the word "*Default*" in the sheet and delete the contents of the cell so that when the macro is re-run the word *Default* is only found once.

Hopefully when the code is searching for the specific word the copy function is not cancelled.

Any help is appreciated, thank you.

Hi arfanvilla,
What is the purpose for doing this?

The user enters a word in a cell then runs the macro to search the data range for the word, once found copy and pastes the row to the active cell.

Where is the data to copy, on a different worksheet?
Is there more than one instance of the search item??
What determines what cell the user selects

To answer your questions - 1. on the same worksheet. 2. only one instance. 3. nothing determines what cell is selected apart from the cell that is selected to begin with (before the macro is run).

Here's what i have and it works, bear in mind that i am not a vba expert or anywhere close to one.

Please Login or Register  to view this content.

if anyone has any ideas on cleaning this up that would be great - at the moment it does what it should, now i will use it in my main spreadsheet (fingers crosssed).