When to set a worksheet object?

Attempting to refine my "Best Practices"...

Does anyone know:

1) If using

Please Login or Register  to view this content.

then using wsGeorge makes the code more efficient, and,

2) if so, at what point (how many references to that worksheet) does it become more efficient? (For I doubt if only once it would have any positive effect at all!)?

Thank-you!

That would depend on what you want to do with Worksheets("George").

Rambling reply.

For your simple example, probably not but using the Index number of the worksheet or the Code Name from the VBA properties window would be (ever so slightly) more efficient.

Where the Object.Object. syntax slows down (processor speed wise) is when walking down the object tree

Please Login or Register  to view this content.

VBA can then reference the range directly instead of having to resolve the various objects down to the range.

Whether or not this makes a noticable difference to the speed of execution is doubtful but if the code is running in a loop then obviously the savings increase with each iteration.

But setting references like that does help coding - there's less physical typing and and can help to avoid typos if you misspell a variable name (You do use 'Option Explicit', of course?)

Maybe we would be better off trying to help you, if you post the complete Code.

Thank-you everyone!

It was one of those conceptual things I was thinking about between cups of coffee this morning - not in any specific instance but in general, aka "Best Practices", and now that I think of it 6StringJazzer, that has come up and bit me with changing tab names. I will start to make the transition!

Any thoughts on best use of "Sheets()" vs. "Worksheets()" when working with regular worksheets?

There's no reason it would matter if you are referring to specific worksheet. But if you are looping and you do something like this:

Please Login or Register  to view this content.

then you might run into trouble if you try to refer to a cell when the sheet is a chart sheet, things like that.

There's no reason it would matter if you are referring to specific worksheet. But if you are looping and you do something like this:

Please Login or Register  to view this content.

then you might run into trouble if you try to refer to a cell when the sheet is a chart sheet, things like that.