Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Page numbers

  1. #11
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Ian,

    Application.CalculateFull

    is the VBA equivalent of Ctrl+Alt+F9.

    Regards,
    Jay

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Excellent! Thanks for that.
    "Have a good time......all the time"
    Ian Mac

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-05 05:55, Jay Petrulis wrote:
    Hi Ian,

    Application.CalculateFull

    is the VBA equivalent of Ctrl+Alt+F9.

    Regards,
    Jay
    Sorry I was a bit hasty, I don't have the option for CalculateFull only Calculate.
    "Have a good time......all the time"
    Ian Mac

  4. #14
    New Member
    Join Date
    Apr 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Err, sorry, VBA is not part of my expertise (hence why I'll go to any lengths to work in Excel)

    But I'm pretty sure that XL97 VBA doesn't have a ctrl+alt+F9 equivalent. Short of Application.SendKeys of course.

  5. #15
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Major apologies. I have Excel 2000 at home and Excel 97 at work. Excel 97 doesn't have the .CalculateFull

    Try,

    SendKeys "%^{F9}", True

    for Excel 97.

    Bye,
    Jay

  6. #16
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-05 08:37, Jay Petrulis wrote:
    Major apologies. I have Excel 2000 at home and Excel 97 at work. Excel 97 doesn't have the .CalculateFull

    Try,

    SendKeys "%^{F9}", True

    Thanks works a treat, I also have 2000 and xp at home and 97 at work, ITS BEEN A LOT OF YEARS SINCE 97 HAS MY COMPANY NOT MADE THE PROFIT NEEDED TO UPGRADE!
    for Excel 97.

    Bye,
    Jay
    "Have a good time......all the time"
    Ian Mac

  7. #17
    New Member
    Join Date
    Oct 2003
    Location
    myrtle beach sc
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i want my workbook to have more then 3 sheets but i can't find how or where to change that at

  8. #18
    Board Regular
    Join Date
    Jun 2006
    Location
    Chicago, Illinois
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    withit45,

    Insert>Worksheet. That's it.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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