Select lines of data that contain words from column F drop down

I'm not sure where you are pasting your code. It should go into a regular module. Hold down the ALT key and press the F11 key to bring up the Visual Basic editor. Click 'Insert' on the menu at the top and then click 'Module'. Paste your code into the window that appears and run the macro from there. The macro will be there whenever you need it.

Do Alt+F8 while you are at excel.This will take you to the Visual basic page. Once you found the module where the code has been pasted(If you have only this, then there you see module), you hit F5. Once the code is run and assuming the code also works, you go back to excel and see the result.

VBA code.pngI have pasted the code into a regular module (entittled 'Module1') The code is pasted in the wondow, then I go back to Excel and go to Macros and there is nothing in the list. Please see the image.

Debug.png

I got this message

Erusso,
The attached is a picture-not much help. It tell us the error number and type.It is like trying the error, but it does not tell us in which line the error occurs.
Jef has now provided you with attachment. It may be easier for you to copy your code in to Jef's book and test it.

This is the error message I am getting.....Anyone familliar with it?

Please Login or Register  to view this content.

Thanks,

ER

The part that is hilighted is in the 4th line

Please Login or Register  to view this content.

ER