Hey guys, I have to admit that the code isn't working in its entirety. The program still does not run through all of the way on the first attempt. I cannot figure out for the life of me why not. It would be greatly appreciated if you could help a brother out.
In light of this issue, I have...
Alright, I see what you are saying. I did the break as you recommended, but I wasn't sure what I was looking for. But I think at this point you are right as far as the time control in the loop. Unfortunately I'm not familiar with that function. How would you suggest I write the block, and where...
SkipVough - I have also tried this route, and it would not work. I had it populated with about 15 sheets. It would work that day, but the following days it would not, If i remember correctly, it said "could not find the webpage data" or something along those lines.
kjv1611 - I changed the block of code like you recommended, noticed a definite increase of speed. Thanks for the suggestion.
If Current.Name = "Sheet1" Then
Else
'Do Stuff
End If
However, I am not too certain what you mean by creating a query table.
Combo - When running the macro...
Hey guys,
This is my first post on here, so be gentle with me. I have obviously created a vb macro that goes out to a website adds the sheet name to the end of the URL, pulls the data from the chart on the website into the respective worksheet for further analysis.
Recently, I have been...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.