improve code

Experts, i created a form to load in ComboBox ALL Installed Fonts on system & sort them. Macro was created in PowerPoint; it takes More than a minute and a Half to finish the execution and show the form. It could be accelerated to reduce it (30 secs for example)? I guess the way that i...

Hello, Below is the code that I am currently using to copy all the rows on each of the specified worksheets based upon a single criteria (Column N="Y"). The Marco then pastes these rows as values on Sheet 4. This code functions properly however, it is extremely slow. The verison of Excel that I...

Hi, i already code some script for renaming the new workbook. But i have trouble to rename it based on condition. Here's the code that i scripted. I've been using this code for a long time. But now i need to put additional condition. Here's what i'm looking for: 1. Insert an additional name in...

Dear all, below is the code that i am using to analyze some data. The code is taking around 2.2 minutes to run. Being a report for senior management this is too long. Please suggest ways so that it runs faster. Option Explicit Dim rw As Long Dim i As Integer Dim count As Integer Sub...