in this example i am looking to test each cell value from sheet one, column C inside a url on sheet 2. The url macro for sheet 2 works, but errors if i try to replace part of it with a url. i am not sure if the macros uploaded with the book, so here is some of it.
Sheet 1
a , b , c
'' , '' , ma
'' , '' , mb
'' , '' , mc
the url for sheet2 is as follows:
http://www.costcentral.com/searchresults.php?keywords=32LX50C&x=8&y=12
the underline bolded part needs to not be hardcoded in. the url needs to be in a loop till all values from C in sheet 1 are tested 1 at a time.
Bookmarks