Very simple Excel Visual Basic question

Discussion in 'General Software' started by Big-Smoot[H], Jun 19, 2005.

  1. Big-Smoot[H]

    Big-Smoot[H] Gawd

    Messages:
    748
    Joined:
    Mar 15, 2002
    okay, it has been almost 5 years since I was an excel VB wiz, so I have forget the most simplest of commands.

    What is the command for shifting your activecell a certain amount of rows & columns.

    I keep thinking it is something like

    activecell.offset(1,0)

    Thanks
     
  2. Big-Smoot[H]

    Big-Smoot[H] Gawd

    Messages:
    748
    Joined:
    Mar 15, 2002
    nevermind, that question. I figured it out.

    But, does anyone know how to turn off the visual performance of the macro? I remember you could turn it off and the macro would run 100times faster.
     
  3. arkamw

    arkamw [H]ard|Gawd

    Messages:
    1,391
    Joined:
    Jan 5, 2004
    Not an Excel scripter myself, but an old boss ran into that issue. It had to do with Excel updating every cell after each calculation (or iteration of a calculation). Unfortunately, I don't remember how he did that. It's been too long.

    [​IMG]
     
  4. pbj75

    pbj75 Limp Gawd

    Messages:
    208
    Joined:
    Sep 30, 2003
    application.screenupdating = false