A Filipino Developers Community
All Tags » excel (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site
  • "Subscript out of range" error when enumerating pagebreaks in Excel

    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...
    Posted to jokiz by jokiz on 05-07-2007
    Filed under: Filed under: ,
  • Closing shortcuts

    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...
    Posted to jokiz by jokiz on 05-07-2007
    Filed under: Filed under: , , , ,
  • Manual Page Breaks and Fit To Page conflict

    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...
    Posted to jokiz by jokiz on 02-28-2007
    Filed under: Filed under: ,
  • Scroll lock and MS Excel

    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...
    Posted to jokiz by jokiz on 03-08-2005
    Filed under: Filed under: , ,
Page 1 of 1 (4 items)
Copyright DevPinoy 2005-2008