Opening webpages on list

hayati

Board Regular
Joined
Oct 3, 2005
Messages
118
Hi there,

This should be pretty simple but I can't seem to figure it out. On an excel sheet on column A I have web adresses - between 5 - 15 of them starting from cell A2.

I would like a macro to go through the list of pages on Column A and open all the pages on a tab in a new explorer.

webpage in A2 opens up on the first tab of a new explorer
webpage in A3 opens up on the second tab of the above explorer
webpagge in A4 opens up on the third tab of the above explorer
.
.
.
webpage in the last cell in column A opens up on the last tab of the explorer.


Thanks for any ideas,
Cheers,
Matt
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
I still can't seem to find an answer for this one. Anyone with any suggestions?

Thanks,
M
 
Upvote 0

Forum statistics

Threads
1,224,590
Messages
6,179,752
Members
452,940
Latest member
rootytrip

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top