Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Steve's Rant (all, worse luck)

    I was amused by Steve's Rant in <post#=529,237>post 529,237</post: > about + and &.
    Mine would be about the absolute reference / relative reference states of the button on the 'stop recording this macro' toolbar.
    The 2 states are scarcely distinguishable to the eye and the tooltip message is identical in each state.
    Is this on MS' shopping list? Could it be? Should it be?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Steve's Rant (all, worse luck)

    I'm quite sure it isn't.

    Mine is about the refedit control (like in the insert, name, define box and the "formula is" boxes on conditional format and validation) and the fact that it always defaults to point-mode (hit an arrow key to move to the left in the formula and get a range address inserted instead) without any visual indication what state you're in.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Steve's Rant (all, worse luck)

    I have an easy type personality and I don't complain easily. I think that there isn't much to rant about in Excel. In my humble opinion, Excel is a brilliant application which extends itself to any type of modifications using VBA. Not to speak of the capabilities of the built-in functions that are so flexible and adaptable.

    If I were to rant....it would be that its limit is 7 nests...not that you'd ever want to go beyond that...and...
    Only 65536 rows, which is extended (anyways) to a couple of million according to Jan Karel in Excel 12!!!
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Steve's Rant (all, worse luck)

    Rudi,

    Your problems will be solved in Excel 12. In addition to the number of columns and rows being increased, the number of levels of nesting that Excel allows in formulas will be increased from 7 to 64.

    For more on the new limits see Microsoft Excel : Some other numbers...

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Steve's Rant (all, worse luck)

    Jan,

    I "feel your pain". I've gotten into the habit of checking in the lower left portion of the screen. I've seen the state indicator in Excel97 and 2000

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Steve's Rant (all, worse luck)

    Good news!
    I followed the link in the previous comment about some other numbers and it said:
    The number of levels of nesting that Excel allows in formulas
    Old Limit: 7
    New Limit: 64

    Now we will really be able to GO CRAZY

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Steve's Rant (all, worse luck)

    Hey, I never saw that!!

    Pity that pressing F2 twice doesn't show Point again, but rather "Enter", as opposed to "Edit" when in edit mode.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Steve's Rant (all, worse luck)

    Can you just imagine a function with 64 nests....it will read like an essay!!! Imagine how long it will take to evaluate that formula using Excels Evaluate Formula feature!!!

    I pity the person who will do this!!
    Regards,
    Rudi

  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Steve's Rant (all, worse luck)

    <hr>I pity the person who will do this!!<hr>
    After I get through with them, I will pity the person who does this on a spreadsheet I have to deal with - which usually means responding to "This doesn't work anymore; can you fix it?" Anyone else who is foolhardy enough to avail themselves of this feature gets what they deserve!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •