Search:

Type: Posts; User: sdckapr; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    14
    Views
    239

    In my experience, since code can be run without...

    In my experience, since code can be run without .Activate and .Select, it is poor practice to use them Using them complexity to the code, slows it down, and can get disconcerting to the user if the...
  2. [SOLVED] I created the attached using the peltier tip you...

    I created the attached using the peltier tip you posted. A stacked bar chart, Some key items:
    Turn the original data into an XY chart after the other groups have been added and put on sec axis
    Use...
  3. I believe that the data table reads the...

    I believe that the data table reads the formatting of the source data and can not be explicitly set. Unfortunately linked data from closed workbooks seems to only look at the values, not the...
  4. Replies
    2
    Views
    66

    You could tell VBA to ignore the errors of the...

    You could tell VBA to ignore the errors of the Pivot items and turn the error handling back on when they are all finished.

    With ActiveSheet.PivotTables("PivotTable1").PivotFields ("Underwriter")...
  5. Replies
    16
    Views
    1,855

    That was fixed in later versions of the code if...

    That was fixed in later versions of the code if you read further in the thread...

    Steve
  6. Replies
    14
    Views
    239

    Another suggestion is not to activate anything,...

    Another suggestion is not to activate anything, but use explicit references

    Dim wkbDSL as Workbook
    Dim wkbQGP as Workbook

    Set wkbDSL = ActiveWorkbook
    Set wkbQGP =...
  7. Replies
    6
    Views
    548

    The easiest way may be for whatever code you are...

    The easiest way may be for whatever code you are using in the other programs to automatically fill in the hidden column, to also replace the value in the row of the other column. How is that being...
  8. Replies
    7
    Views
    170

    The equation in K9 starts:...

    The equation in K9 starts:
    =IF(SMALL(J10:J14,1)=0,J11,....

    Since small(J10:J14,1)=0 it evaluates to TRUE and puts J11 into the cell (which is 0. It does not to evaluate anything else in the...
  9. I think the easiest way would be to add an...

    I think the easiest way would be to add an additional column in the raw data that contained =ROW() formula to indicate the row.

    Then in Pivot table add a new value field, which is hte mininum of...
  10. Replies
    8
    Views
    230

    [SOLVED] I don't understand. Where are you entering the...

    I don't understand. Where are you entering the value that triggers the selection of a different cell? Also do you want the value in C to cease being the lookup formula and being the value you enter?...
  11. Replies
    4
    Views
    161

    That was an example. you could use any text...

    That was an example. you could use any text string, literal, from a variable, the textbox.value:
    ActiveWorkbook.FollowHyperlink Address:=txtfile1.value

    Steve
  12. Replies
    4
    Views
    161

    You can use the line of code: ...

    You can use the line of code:

    ActiveWorkbook.FollowHyperlink Address:="http://www.radionz.co.nz/news/national/256183/severe-weather-forecast-but-short-lived"

    Steve
  13. How about this code? Option Explicit Sub...

    How about this code?



    Option Explicit
    Sub AnimateChart()
    Dim rX As Range
    Dim x As Long
    Dim y As Long
    Dim iCols As Integer
  14. Replies
    12
    Views
    382

    There is no attachment. I presume that sum of the...

    There is no attachment. I presume that sum of the COUNTIF of the present and COUNTIF of the excused divided by the total count should work. But without know the setup, it is difficult to be more...
  15. Replies
    15
    Views
    475

    Does this modification to your code work? I just...

    Does this modification to your code work? I just took the total you get and divided it by the number of cells in the range and then convert that number.

    Public Function AvgGrade(rng As Range) As...
  16. Could you elaborate on what you need in excel? I...

    Could you elaborate on what you need in excel? I don't understand what you want the chart to look like and what you want animated. [perhaps you could attach a picture of what you need].

    For...
  17. Replies
    9
    Views
    231

    This question was asked and answered earlier. Is...

    This question was asked and answered earlier. Is there a reason you posted it again?
    If you are looking for a modification of RG's formula:...
  18. Replies
    9
    Views
    231

    Something like: =min(100, 'selected...

    Something like:
    =min(100, 'selected cell'/15*100)

    Steve
  19. Replies
    3
    Views
    139

    Is the code located in the ThisWorkbook Object?...

    Is the code located in the ThisWorkbook Object? It needs to be located there.

    Steve
  20. Replies
    4
    Views
    162

    Some formulas must be entered explicitly as an...

    Some formulas must be entered explicitly as an array (ie using the ctrl-shoft-enter). Some formulas implicitly work with arrays (sumproduct, index, etc) so the formula does not explicitly need to...
  21. Are all the rows unhidden in both the copy and...

    Are all the rows unhidden in both the copy and the source?

    Steve
  22. Replies
    3
    Views
    107

    This is not a bad source for the information:...

    This is not a bad source for the information: http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-HP010342372.aspx

    Steve
  23. Replies
    5
    Views
    220

    The IRR can get a Div/0 error on some occasions...

    The IRR can get a Div/0 error on some occasions if during the iterations the function gets that type of error internally. I think having the values flip too much between positive and negative can do...
  24. Replies
    5
    Views
    220

    Same as before: details of a specific example and...

    Same as before: details of a specific example and how you are calculating it, so we can try and understand the issue.

    Steve
  25. Replies
    5
    Views
    220

    could you provide details of the situation or at...

    could you provide details of the situation or at least an example that we can work through. Also what is an "EAY"?

    Steve
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4