Clean up code

**madhatter40** · 10-11-2014, 08:20 AM

I am looking to see if any of the following code could be cleaned up? Any help would be greatful

Please Login or Register  to view this content.

**apo** · 10-11-2014, 09:09 AM

Perhaps post a sample Workbook and a detailed explanation of what you want to do..

There's many ways your code coudl be cleaned up..

Example:

Please Login or Register  to view this content.

Could be :

Please Login or Register  to view this content.

But, regardless.. a Workbook attached an clear explanation will serve your needs better..

**TMS** · 10-11-2014, 09:21 AM

Another common example:

Please Login or Register  to view this content.

can be written:

Please Login or Register  to view this content.

That will remove the need to select cells, etc.

Given that a lot of the code is repetitive, you would do better to create a subroutine that executes the common code. Sometimes, only one parameter varies and, in that case, it could be passed to the subroutine.

Regards, TMS