-
I had an issue yesterday with my previous Excel VBA project where the user is experiencing the very common: Run-time error '9': Subscript out of range Surprisingly, i found out that the said exception was being raised on a foreach construct for the pagebreak collection specifically when it hit...
-
if you're a keyboard junkie, you might have mistaken to close that Visual Studio Tool Window (resharper's find usage is a prime candidate) with an Alt+F4 keystroke and when you don't have any changes to save, your slow VS which took you almost a minute to load is now closed. Next time, just...
-
I've been struggling for hours why i couldn't make a manual page break after i did a fit to page width configuration for a worksheet in my task only to find out about this kb here , and a post from usenet here . I later found another post about the problem here . At first, i ignored the reply of the...
-
I was using Excel yesterday when I tried to scroll the cells using the arrow keys yet the scrollbars (horizontal and vertical) are the ones moving. I immediately tried F1 to find out the problem (of course it should be a simple setting on/off) but unluckily I cannot find any. Maybe because I'm in a rush...