PDA

View Full Version : Search entire column for word/phrase and list results



markhas
08-18-2010, 02:00 AM
I am a VBA newbie and would like to modify an add-in provided by user mdmackillop. I can't pm him, so I will go the route of posting this question here.

This code is called:
"Search all worksheets for word/phrase and list results with hyperlink to cell"
I can't post links since I don't have a post count = to 5 but the article is as follows:
kb_id=780

This add-in would be useful for me if it were modified to search the currently selected column for a list of words or phrases, instead of hard-coding it to "B" (2).

The way I plan to use it is to select the entire column and then run the add-in against it.

I was wondering if the code could be modifid to use ActiveCell.Column or ActiveCell.EntireColumn.Cells or some other form of these calls to replace the hard coded "With WB.Sheets(WS.Name).Range("B:B")".

Thanks for your help