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

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

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

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

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