I have written two identical Macros using Visual Basic. The only difference
in the code are the variables that are inputted. the code contains
directions that cause lines to be hidden or cells to be erased based upon
either the color or content of the cells. One macro runs fast but the other
runs very slow. Ive contacted IBM and they say it is not the processor.
When viewing the code in the debug mode the selection.clearcontents seems to
cause a pause in the execution but only in the one macro.