help with code formatting

[ammartino44]

Hello. Can someone please correct the code for me below (in terms of indenting, and effeciency) That is, if there are any ways the code could be written better, please let me know how and why? How do you organize all the dim stuff? Spreadsheet attached.

Sub mellow()

Please Login or Register  to view this content.

[Norie]

For help with indenting take a look at Smart Indenter.

[daffodil11]

Adhering to some semblance of popular naming conventions helps you proof your own code down the road, and indentation makes it easier to follow.

The more complex my code, the stricter I follow some of the basic guidelines.

Please Login or Register  to view this content.

The free VB Editor addin MZ tools has a few handy features as well.