+ Reply to Thread
Results 1 to 17 of 17

Contour Graphs

Hybrid View

maani Contour Graphs 08-24-2009, 09:36 AM
Andy Pope re: Contour Graphs 08-24-2009, 11:26 AM
maani re: Contour Graphs 08-24-2009, 11:41 AM
Andy Pope re: Contour Graphs 08-24-2009, 11:45 AM
maani re: Contour Graphs 08-24-2009, 12:01 PM
maani re: Contour Graphs 08-26-2009, 05:37 AM
Andy Pope re: Contour Graphs 08-26-2009, 07:36 AM
maani re: Contour Graphs 08-26-2009, 07:49 AM
Andy Pope re: Contour Graphs 08-26-2009, 07:52 AM
maani re: Contour Graphs 08-26-2009, 10:18 AM
  1. #1
    Registered User
    Join Date
    05-26-2009
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    76

    re: Contour Graphs

    Would this be correct?

    Sub Dynamic_Table()
        
    Dim RowC, Colc As Integer
    Dim CRow, CCol As Integer
    Dim i As Integer
    Dim lngCalcMode As XlCalculation
    Dim SupName As String
    
    Application.ScreenUpdating = False
    lngCalcMode = Application.Calculation
    Application.Calculation = xlCalculationManual
    
    'Delete the Data from "Data for Pivot"
    
    With Sheets("Data for Pivot")
        .Range("A3", .Range("A3").End(xlDown)).Clear
        .Range("A3", .Range("A3").End(xlDown)).NumberFormat = "dd/mm/yyyy hh:mm"
    End With
    
    ' Dynamically count Data in BBG Raw Data sheet
    
    With Sheets("BBG Raw Data")
        .Range("A4", .Range("A4").End(xlDown)).Copy
        Sheets("Data for Pivot").Range("A3").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Application.CutCopyMode = False
    End With
    
    Application.ScreenUpdating = True
    Application.Calculation = lngCalcMode
    
    ' Also update the chart
    
    X_Axis_Scale
    
    End Sub

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    re: Contour Graphs

    Correct in the sense of the code yes.

    What state is calculation in when the routine has finished?
    Perhaps the X_Axis_Scale routine is changing things as well.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-26-2009
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    76

    re: Contour Graphs

    It's in automatic except data tables. It seems to be working. The only issue is that my original worksheet (this is a condensed version) is very large and thus it takes quite a bit of time everytime the data tables recalculate. is there a way to make the recalculation of the data tables go faster? Or to have the data tables not recalculate upon saving the worksheet?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1