too long

  1. J

    Can you make this Code smaller, and minimize the time of execution?

    hello, can you help me with that code, i'm new with excel (you can say that, i don't know a thing about it), i just create this code by: copy and past from here and there,, without knowing excatly what it does mean.. but, he is work perfectly. now i have a small problem, the code is taking too...
  2. C

    Excel userform takes too long to process the data

    Hey guys, I'm new here and have a beginners questions. I have created a userform for data entry (code below). The form takes approximately 12 seconds to transfer the data to the spreadsheet. I have tried the recommendations in the following page...
  3. R

    VBA Running slow

    Good afternoon everyone, I have been playing around with some simple VBA code and come across this one in the forum that hides all rows where there is a "0" in the cells of column J: Sub Hide() Application.ScreenUpdating = False Dim wks As Worksheet Dim Lastrow As String Dim Rng As Range Dim...
  4. P

    How to overcome the "Formula too long" error on windows excel...

    I have worked on this really difficult long formula, but the problem is, I have been working from my Mac. And my office, which this formula was made for, is all PC. Now generally this isn't a problem, but apparently PC's have a limit on how long the formula can be. Is there anyway to overcome...
  5. S

    Not a Valid Name

    I created a macro that would go into 20 folders and copy the data and paste it into the workbook. It is working fine but a friend showed me how to write (I believe they are called) arguments and since other departments are going to start to use the workbook it makes since making an "argument"...

Some videos you may like

This Week's Hot Topics

Top