The range is being used like database with 6 column fields.I want to be able to identify the tw rows within the range. The data displays multipl machine stats over various hours over various dates.What I am really trying to do is define the range wit these two values. They are limited to only using predefined letters, or printing each letter individually for every customer. Order By0n = True End Sub -- Message posted via Access create a data table from an imported graph I use Excel 2003, I have a graph send by email with all the values on the graph line. pieter Have a look at the shareware program Grab It wishes -- Bernard V Liengme ca/people/bliengme remove caps from email "pieter V" I use Excel 2003, I have a grap..to do self-defined regression in excel? The Analysis Tool Pak - VBA addin has a regression function and probably everything else you want.Error received when users attempt to use a custom letter: -------------------------------------------------- Unhandled script exception: Cannot find report "COL_Reminder_Upcoming Due". I like to make a table of all the data on the graph line, but I have not found a way to do that. Hi, I want to do regression ananlysis in excel using a sigmoid function, which is not offered in the general 6 functions in excel(by adding trendline). Tools functions in excel(by a..is the most efficient way to move data across network?I finally had enough with my procrastination and I added the code yesterday, tested today, and am now uploading to share with the world.
Most of the code examples that are more than a couple of lines long are actual working code that really do something that can be seen. Color = RGB(i Top Row Fill RGB1, i Top Row Fill RGB2, i Top Row Fill RGB3) global Wksht. B5&","&B6 ; semi-colon (;) in VBA can be used instead of ampersand (&) in the PRINT or WRITE statements EXAMPLE: Print #1, "Value of X="; x; vb Cr Lf; "value of y="; y % percent sign (%) in VBA forces a numeric to work like an Integer @ at sign (@) in VBA forces a numeric to work like currency ! ) in VBA forces a numeric to work like the data type of Single In Excel formulas, it divides between a worksheet name and its range e.b. A2: C9 $ in VBA, the dollar sign ($) forces a numeric to work like a String In Excl formulas that are copied to another cell, a dollar sign before either the column letter and/or the row number tells Excel NOT to increment/decrement the value immediately after it. Type as the very first line "option explicit" and hit OK. This line forces the editor to validate some things in the code. Once you leave a line, VBA Editor does some formatting and syntax checking every time you go to a new line. Cut-and-paste the below code into the VBA Editor window: ' PURPOSE: in a 7-paired-columns x 8-row grid, show the values and color for all 56 values of the Color Index property Sub Color Indexes() ' in a constant value variable, set up some values. Column Width = 7 ' set the width of odd # columns to 7 pixels Range("B: B, D: D, F: F, H: H, J: J, L: L, N: N"). One other thing to know at this point: that right-pointing arrow can be clicked-and-hold then dragged up or down to another line to make it the next line to execute with the F8 or F5. Click on "Sheet2" to make another worksheet the "active worksheet". Click into the VBA Editor window and go to the bottom after all existing code lines. Address, "$")(1) Else s Col Ltr = "" Columns("A:" & s Col Ltr). Add Key:=Range("E1", "E" & l Row), Sort On:=xl Sort On Values, Order:=xl Descending End With .
When I first starting really getting into VBA, it was pretty invaluable to me to be able to read over my code. Some of these add-ins were (a list of which can be found here) Colo’s HTMLMaker, Excel Jeanie 4, ASAP Utilities, etc. A few years ago I asked Juan Pablo González, original developer of the VBHTMLMaker add-in (amongst other collaborators) if I could amend his add-in.
There are a few add-ins to help you post things to make it present nicely when viewed.
which obviously isn't working because the screen updates a whole lot afterwards. I almost wish this were more complicated; the fact that everything looks so simple is making it difficult to think of what could possibly be happening! So this morning application.screen Updating was working as expected. The test code that I wrote is below: Sub test() Debug. One thing that seems to be common among those modules not working, is that they all contain code that changes worksheets. In any case, it's a real mystery why this happens from one day to another!
I started to debug, and immediately after the "Screen Updating = false" line executes, I go to the immediate window and type: Debug. Any clues on how to solve it would be greatly appreciated. Screen Updating = True End Sub _________________________________________________________ Private Sub Check_for_Open_Workbook() Application.
Sub load Portfolio() Dim i Test As Integer, portfolio Version As String Application. :-) Basically, after all those statements (and between each one) Screen Updating remains "True". Screen Updating = False For i = 1 To 10000 Worksheets("Sheet1"). Screenupdating = False worked perfectly in Excel 2007 until last week, when it remained True however many times I tried to set it to False.