XPathOnUrl - Reference Cell For URL

Support
#1

Hi,

I'm trying to extract some data from a bunch of pages using XPathOnUrl.

In the URL field I'm trying to reference a cell that contains the URL to check rather than having to insert each URL into the formula separately, however when I insert a cell number into the URL field within the formula it says the URL is invalid.

How can I reference a cell within the formula so it works?

Thanks,
Jamie

#2

Post your formula.

(But I'm guessing your need to remove the "" around your cell reference. That's a common mistake.)

1 Like
#3

Bingo.

Cheers Niels!