Deleting parameters to save running time?

I notice that some instructions in my macros can be shortened, thereby saving nanoseconds of running time (presumably !), and the end result of the operation is still the same.
But is it so? Are there any drawbacks? is the time saved worth it, when I have to run many such instructions?
Some instances:

1)

Please Login or Register  to view this content.

shortened to

Please Login or Register  to view this content.

2)

Please Login or Register  to view this content.

shortened to

Please Login or Register  to view this content.

3)

Please Login or Register  to view this content.

shortened to

Please Login or Register  to view this content.

Thanks for any enlightened answer.
ACA

Hello aca,

(1) When programming in VBA, it seldom necessary to Activate an object before an operation can be performed. Activating an object wastes a lot time as this primarily done for visual presentation.

(2 & 3) Objects generally assign default values to all the properties they contain. However, the help files do not always provide that information. Generally, you do not have to set all the properties of an object as these values remain in effect only for the lifetime of the object. Two notable exceptions are the Find and Replace methods for a Range object. Most all of the values are retained because VBA hooks into the Windows Find and Replace dialog.

Following up on what Leith said, if you do something simple like find/ replace or copy/ paste in a few cells, then you (as a human) will not feel any added advantage to learn efficient coding practices. Now on the other hand, if you are going through a million cells and doing the same task then efficiency can save you hours to days of headache. You can even time these processes (through vba) to see exactly how long two different processes really took. I have some codes that runs for days at a time and so every minor tweaks shaves off unneeded time to complete the task.

Hi,

If you are satisfied with the responses, then please mark the thread as Solved (instructions in the Forum Rules and FAQs).

Good luck.

abousetta