Hold down CTRL, right click on the sheet and do Edit Query and then hit c the
second it comes up. The address is what is active when you do this, so that
should copy it to your clipboard. Then just paste into your sheet somewhere.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Shatin" wrote in message
...
My friend has given me a workbook with several worksheets. Each worksheet is
linked to a webpage. When I refresh the worksheets, they work fine. Trouble
is I don't know to which webpages the worksheets are linked, and I want to
know what the URL of each webpage is. However, when I choose Data | Import
External Data | Edit Query to check what the URL is, the URL is quickly
redirected to another web page. I never get the chance to see what the
original URL is. How can I, by using VBA or otherwise, display the URL's of
the linked worksheets?

TIA




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.587 / Virus Database: 371 - Release Date: 12/02/2004