Hi all
I have a range C7: D12.
C contains a URL and D contains a generic name.
The are both named ranges (URLs and Names).
I need macro that will loop through each Rng in URLs and...create a new tab using the adjacent index of Names, and on this new tab run a web query using the URL value...
This loop will solve a huge problem I have been facing, and can then build a summary
?
I have a range C7: D12.
C contains a URL and D contains a generic name.
The are both named ranges (URLs and Names).
I need macro that will loop through each Rng in URLs and...create a new tab using the adjacent index of Names, and on this new tab run a web query using the URL value...
This loop will solve a huge problem I have been facing, and can then build a summary
?