Select, Activate, Or Application Goto?

[indi visual]

Which is Faster?


Range("A1").Select

Range("A1").Activate

Application.Goto (ActiveWorkbook.Sheets(1).Range("A1"))


I am cleaning and condensing a lot multiple selects and redundant lines of code.


I read a few places here and there about avoiding select and activate if all possible.


Accuracy and speed is my aim with clean written code.


Does anyone have any tips for things to avoid that slow your code down the most?

 

[Dee]

Hi,


These links may help you...


http://www.avdf.com/apr98/art_ot003.html

http://www.cpearson.com/excel/optimize.htm


Happy coding....

 

[Hui]

@Indi

You haven't said why you even need to select or activate the cells

A lot of functions can access cell values/properties without selecting them first

 

[indi visual]

Thanks Dee I checked them out good stuff.


Hui, I have so much random code thrown together I'm not even sure I couldn't exactly explain how I'm using it. Overall however I'm basically running a lot of search and replacements.


I have last question with this post. I have two subs, will my code be faster if I make it all one sub instead of two?

 

[Hui]

@Indi

No, Subroutines are normally used to segregate blocks of code that can then be called / reused from multiple sources or that performs set tasks

 

[indi visual]

Good stuff thx Hui.