Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.15 seconds.

  1. It would be much simpler to use one sheet for all...

    It would be much simpler to use one sheet for all the data instead of one sheet per month. It will make reporting far easier.
  2. Replies
    12
    Views
    263

    If you are on a network you may be able to...

    If you are on a network you may be able to restrict access to particular users or groups using Review - allow users to edit ranges.
  3. Replies
    13
    Views
    373

    That's odd because it works for me (albeit on...

    That's odd because it works for me (albeit on Win7) and it's the code equivalent of typing what you posted at a command prompt, so if that works, so should the code.
  4. Replies
    13
    Views
    373

    Try: shell "cmd /c net stop osppsvc"

    Try:

    shell "cmd /c net stop osppsvc"
  5. Replies
    4
    Views
    193

    FWIW, no need to select anything there: Sub...

    FWIW, no need to select anything there:

    Sub CreateButton7()
    With ActiveSheet.Buttons.Add(143, 10, 143, 40)
    .Name = "Button 7"
    .OnAction = "PrintMenu"
    .Caption =...
  6. Replies
    18
    Views
    696

    A propos the original issue, in the interest of...

    A propos the original issue, in the interest of brevity I would use:


    application.Goto range("rangename")

    instead of locating the sheet name etc.

    IMO, brevity should never be an end in and...
  7. Replies
    4
    Views
    178

    You can automate the filtering but it's hard for...

    You can automate the filtering but it's hard for us to provide useful code without seeing the layout of the workbook.
  8. Replies
    4
    Views
    178

    Filtering the chart data would be the simplest...

    Filtering the chart data would be the simplest thing, since the chart will default to not plotting hidden rows.
  9. Replies
    21
    Views
    1,097

    So why bother storing it as text, since you lose...

    So why bother storing it as text, since you lose the precision anyway? ;)
  10. Replies
    21
    Views
    1,097

    Why does it need to be a number? Are you planning...

    Why does it need to be a number? Are you planning to do mathematical operations on it?
  11. Replies
    19
    Views
    995

    If you use CDate when reading from/writing to the...

    If you use CDate when reading from/writing to the cell, it will respect the user's regional settings, which is usually what you want.
  12. Replies
    26
    Views
    1,464

    You can do it directly with data validation...

    You can do it directly with data validation alone. Using the example workbook, select A2:C25, choose Data - Validation, select Custom and enter this formula:...
  13. Replies
    14
    Views
    741

    You have to refresh the pivot table but that's...

    You have to refresh the pivot table but that's all.
  14. Replies
    14
    Views
    741

    I don't think I have 64bit 2010 installed...

    I don't think I have 64bit 2010 installed anywhere. If I find the time I'll set up a VM to see what you have in that file.
  15. Replies
    14
    Views
    741

    2010 or 2013?

    2010 or 2013?
  16. Replies
    14
    Views
    741

    I can't open that file - what version of Excel /...

    I can't open that file - what version of Excel / Power Pivot are you using?
  17. Replies
    14
    Views
    741

    OK. First you need to convert the Database range...

    OK. First you need to convert the Database range into a Table.
    Then I suggest you clean up your data columns so that they contain numbers only not text like "-".
    Then on the Power Pivot tab, click...
  18. Replies
    14
    Views
    741

    If you don't want to use Power Pivot, zeddy's...

    If you don't want to use Power Pivot, zeddy's solution is the simplest. :)
  19. Replies
    10
    Views
    643

    UDF version: Public Function...

    UDF version:


    Public Function UniqueColleges(sColumn As String) As Long
    Dim ws As Worksheet
    Dim oDic As Object
    Dim LastRow As Long...
  20. Replies
    14
    Views
    741

    No it isn't. A calculated field wouldn't work for...

    No it isn't. A calculated field wouldn't work for this because it will sum the columns before performing any other operation, so if you create a column using:
    ='Tonnage w/ grade' * '%Fe'

    it will...
  21. Just: Set BaseWks = ActiveSheet

    Just:

    Set BaseWks = ActiveSheet
  22. Replace: Set BaseWks =...

    Replace:

    Set BaseWks = Workbooks.Add(xlWBATWorksheet).Worksheets(1)
    with this:

    Set BaseWks = ThisWorkbook.Worksheets.Add
  23. If all the numbers are divided by the same...

    If all the numbers are divided by the same denominator, just sort the number column and the ratio will follow suit automatically.
  24. Replies
    5
    Views
    319

    Congrats, one and all. :)

    Congrats, one and all. :)
  25. Replies
    8
    Views
    509

    Just as an alternative UDF: Function...

    Just as an alternative UDF:


    Function TAT(cell As Range) As String
    Dim zValue
    Const clMAX_BAND As Long = 8

    zValue = cell.Value

    If Left$(zValue, 1) = "-" Then
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4