You can use the .FollowHyperlink method but depending on the webpage you might be better using a webquery to load the pages' contents into a specific sheet/cell.