Make your office life easier with simple and fast Excel VBA solutions.
If You want to check if link is still active, You will just click it and see if site is online. But what should You do if You got 1000 links to check? Or more? In this article I’ll show You how to use WinHttp Request to get your site status.
In this post I want to present You the most common error associated with array creation which is Run-time error ‘9’: Subscript out of range.
You probably declare the scope of the data in your macros very often. And You want to feel convenient in every case with it. In this post I am going to present You my 5 simple ways of how to declare Excel range in VBA.
There are variables assigned to array. Will variables value change, if array values change?
I don’t want to make a duplicate of official Microsoft Office website, because it is not the case and I see no point in it. You are here, because You were there. Now You are looking for more details or examples how to declare array to deal with common, daily tasks.
Continue reading “How to declare array in Excel VBA?”In my previous post I already described how to create simple progress bar and how to implement it into code. It is so much better to watch the macro performance, than freezed screen. In case You have to stop macro, it is even easier to do this with bar, than without it. But I have never thought about what impact have that visualization of progress bar on macro performance.
Continue reading “Progress bar refresh – macro performance”