Very simple Excel Visual Basic question

[Big-Smoot[H]]

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

 

[Big-Smoot[H]]

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.

 

[arkamw]

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.

 

[pbj75]

application.screenupdating = false