Hi Dallman,

Super that this was able to help you, Feltra. Also interesting to
hear how you tackled the Immediate-window testing. I might use that
sometime myself!

Well, I hope I didn't sound too fancy... I am sure you must be
already knowing what I am describing below.... What I did was this:

1. First, Record a macro for the WebQuery thing that I want to do
2. Position / resize the Sheet window and the VBA Editor window so
that I can see both at the same time (visually).
3. Run the macro... The data (from the web) will appear on the sheet
(in the lower half of the screen) where I can see it.
4. Manually position the activecell to the cell I want to check out [I
do this by clicking on an empty adjacent cell and then use arrow keys
to position to the cell i want.. Clicking directly may cause un-needed
effects like say going to a web page, if that cell has a hyperlink].
4. In the VBA Editor (that is on the upper half of the screen) invoke
the immeidate window.
5. Simply type in: ?ActiveCell.Hyperlinks(1).Address


Thanks & Best Regards,
-feltra