Hi,
I have 32 worksheets and use the following piece of code to cycle through them and refresh the web data contained within each sheet. I'd like to create a more efficient loop to perform this task
Many thanks in advance
Please Login or Register to view this content.
Perhaps targeting the WebQuery objects indirectly will get them all wherever they may be in the workbook:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
perhaps
but with 2010 you may needPlease Login or Register to view this content.
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi thank you both for your help, 1st answer works perfectly. Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks