Excel 2003 VBA: Find Method with Variable

My problem is with the line beginning "Selection.Find."

I want it to paste the clipboard contents into the search box, but it's
remembering the specific value used when I set up the macro (i.e. copied the
keystrokes).

Please Login or Register  to view this content.

Thanks for any help

You need to get the search value from "somewhere". This could be from an InputBox or by putting the data in a cell. The value in the cell could be from a Data Validation drop down box based on data in the spreadsheet, that is, a list of (unique) values.

Let's say the data you want to search for is in cell A1, the line would look like:

Please Login or Register  to view this content.

But you don't need to select the column first; you can use:

Please Login or Register  to view this content.

Regards

TMShucks is correct in that using a cell is probably better than the clipboard, you don't really need to copy it into memory first.

But this routine WILL put the current clipboard contents into a usable variable:

Please Login or Register  to view this content.

To use this method you will need to add a reference to Microsoft Forms 2.0 Library. (VBA > Tools > References)

Based on your original code:

Please Login or Register  to view this content.

I assumed you were copying back to the current workbook.

It also appears that this is probably inside a loop, in which case all the selecting you are doing is unnecessary and slows the code down - if you post the full code, I'm sure we can streamline it.

e.g.

Please Login or Register  to view this content.