long code

Hi, I have a code that excel has generated from the "record macros" function. It doesn't always execute correctly. 1. Please review the macro and correct any issues that you may find. 2. Is there a way that a macro can include a specific printer and printer settings? 3. is there a way that a...

Hello people, I have made a very long code.... But I want to make it shorter, but I don't know how... I got thoughts about create a kind of an array/case/for loop instead, have someone a suggestion how to make this code shorter? Sub GetColData() 'This function Get all the column data from the...

The cells B7, C7, D7 denote the sides of a triangle. The following code should tell me whether the triangle is right or not. In "B7^2+C7^2=D7^2, B7^2+" it detects the cells B7, C7, D7, but after that none of the cells in "+D7^2=C7^2, C7^2+D7^2=B7^2" is detected and the B7, C7, D7 there look...

Dear All, I have developed an algorithm that manipulates a large number of considerably large Excel files (please refer to the summary at the end). When I work with few files only, I have no problem with any computer. When I increase the number of files, however, the process doesn't work with...

Alright. So I'm in the process of automating a good bit on my groups daily spreadsheets. For one UserForm though, I have about 1,400 lines of code. I'm trying to streamline some things. Can this bit of code be condensed from 86 lines to maybe 50 lines? Here's the code: Private Sub...