Optimizing VBA

[walduxas]

Hi,

that's probably an old question and I did a lot of search about optimizing VBA code. However, I got confused about cell referencing optimization, for instance, should I use Range("A1") or [A1] referencing?

These two links are a bit conflicting about this idea:

http://www.excelitems.com/2010/12/op...er-macros.html
http://www.cpearson.com/excel/optimize.htm