As ALWAYS, post your code for comments. But
xxxxxx" & range("b24") & "yyyyyyyyyy
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CM4@FL" wrote in message
...
I want my web query to change according to the value within cell B24. Can
someone please help me with VBA Code?

Thanks in advance