Function to search for a string, return address of Nth occurance.

Hello again ExcelForum friends!

Lately I've been using excel to copy web pages and then run a macro to turn it into a usable set spreadsheet of data but the paste results keep slightly shifting cell locations. Would it be possible to do something like the following?

Here is a sample file: Attachment 335650 to keep us on the same page.

I was thinking a function SearchCells() and it would work something like SearchCells("Sample", 1) would return the cell location "B4" and SearchCells("Sample", 2) would return the cell location "C4". SearchCells("Sample") would just default to first "Sample" found.

All help and suggestions appreciated!

Here is what I have so far.

Please Login or Register  to view this content.