shorter code

  1. E

    make shorter code

    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...
  2. BigMoe

    Need help in shortening formula.

    *** I'm using Excel 2003 *** This is more of a general question because I don't have the whole formula 100% figured-out, but I would appreciate some direction on how to either make the formula below shorter (I've run into the Excel limit) or go about it in a more efficient way (without VBA...
  3. fucell

    Anyone can shrink this code?

    is there a way to shorten this code ? Range("b2").Value = frmquote.txtdate.Value Range("b3").Value = frmquote.txtquote.Value Range("b4").Value = frmquote.txtsalesman.Value Range("b5").Value = frmquote.txtdterequired.Value Range("b8").Value = frmquote.txtCompName.Value Range("b9").Value =...
  4. fucell

    TextBox Properties

    Hi to all.. I just want to ask if theres a way to enable and disabled 8 textbox in a shorter code (excek macro). below is my code txt1.enable = true txt2.enable = true txt3.enable = true txt4.enable = true txt5.enable = true txt6.enable = true thanks in advance. fucell
  5. T

    Make the code crisper to enhance performance

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top