Hi Everyone,
I have a pretty simple question (i belive). I am writing a procedure and want it to repeat until a certain column.
So i have:
Do until activecell.column = 100
Blah blah blah
Activecell.offset(0,1).select
Loop
The "100" isn't being recogonized and the macro keeps...
Hi Everyone,
I'm running a webquery in EXCEL and want to do some analysis with the data afterwards. Does anyone know how to write the code that tells Excel to wait 10 seconds while the webquery is in progress so that the web query can complete? Thanks.
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.