Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    2
    Views
    24

    [SOLVED] You could simply add a line Sub ShowAGames()...

    You could simply add a line

    Sub ShowAGames()
    ' ShowAGames Macro
    ' On a weekly page, moves the cursor to show the Tuesday and Wednesday games
    '
    On Error Resume Next
    Application.Goto...
  2. Can I ask why you want to run the query in Access...

    Can I ask why you want to run the query in Access rather than doing it all in Excel?
  3. What information do you want back and how would...

    What information do you want back and how would you like to view it (or what do you need to do with it)?
  4. Do you really want to open the query in that...

    Do you really want to open the query in that instance of Access rather than, say, showing the results in Excel?

    Also, cross-posted here:...
  5. Replies
    5
    Views
    130

    In 2010 and later, it's actually pretty simple...

    In 2010 and later, it's actually pretty simple since you can use the DisplayFormat property added in 2010 to get the colour of a cell even if it's the result of CF.
  6. Thread: Trimming VBA Code

    by rory
    Replies
    14
    Views
    233

    It is true that having pointed out the problem...

    It is true that having pointed out the problem with Steve's original posted code, I then repeated it! :o

    I would use something like this (though I'd prefer sheet names to assuming the correct...
  7. Replies
    16
    Views
    315

    Yes, exactly that.

    Yes, exactly that.
  8. Replies
    16
    Views
    315

    Your weight and temp charts don't use the entire...

    Your weight and temp charts don't use the entire table columns as their source, so you don't get the benefits of the dynamic ranges.
  9. Replies
    4
    Views
    126

    What is in D13? Does it help if you put a space...

    What is in D13? Does it help if you put a space before the text:

    ActiveSheet.PageSetup.CenterFooter = "&25 " & Range("D13").Value
  10. Replies
    16
    Views
    315

    Can you post the workbook with any confidential...

    Can you post the workbook with any confidential information removed/altered?
  11. Thread: Trimming VBA Code

    by rory
    Replies
    14
    Views
    233

    The problem is trying to apply Range to a...

    The problem is trying to apply Range to a Workbook object rather than worksheet:


    Dim wkbDSL as Workbook
    Dim wkbQGP as Workbook

    Set wkbDSL = ActiveWorkbook
    Set wkbQGP =...
  12. Replies
    3
    Views
    109

    It is much simpler to change your code to use...

    It is much simpler to change your code to use late binding and dispense with the references altogether, IMO.
  13. I'm not talking about the data link. If you...

    I'm not talking about the data link. If you change the number format (I don't know if you're talking about axes/datalabels/other) so that it's manually set to a Percentage and uncheck the 'linked to...
  14. Are the formats linked to source? That would do...

    Are the formats linked to source? That would do it - if the source is closed the format isn't read, only the value.
  15. Thread: Debugging code

    by rory
    Replies
    15
    Views
    359

    I always have the Locals window and Immediate...

    I always have the Locals window and Immediate Window at the bottom of the VBE window so I can keep an eye on variable values and run quick checks in the IW. I also use the Watch window occasionally....
  16. Replies
    25
    Views
    926

    Do you have the file preview showing in Explorer?...

    Do you have the file preview showing in Explorer? That can cause issues.
  17. Thread: Debugging code

    by rory
    Replies
    15
    Views
    359

    Hard to know how you do it and what to suggest,...

    Hard to know how you do it and what to suggest, but you could start by reading this page: http://www.cpearson.com/Excel/DebuggingVBA.aspx
  18. Replies
    8
    Views
    209

    I don't think you can do this with a simple...

    I don't think you can do this with a simple number format with centre alignment.
  19. Replies
    8
    Views
    209

    Format them as: 0_X;-0_X_X;0_X;@ and that...

    Format them as:
    0_X;-0_X_X;0_X;@
    and that should work for single digit numbers.
  20. Replies
    8
    Views
    209

    Unless you use a fixed width font, no placeholder...

    Unless you use a fixed width font, no placeholder will work since letters are shown in different widths.
  21. Replies
    5
    Views
    159

    Just bear in mind that if you use Option Explicit...

    Just bear in mind that if you use Option Explicit - and you should - that solution won't work since, as I said, Blank is just an undeclared variable and not an intrinsic VBA value. Of course you'll...
  22. You could use: With...

    You could use:

    With ActiveSheet.PivotTables(1).TableRange1
    .Resize(.Rows.Count - 1).Offset(1).Select
    End With
  23. Replies
    5
    Views
    159

    Or equally: If UserValue = fish Then Exit...

    Or equally:

    If UserValue = fish Then Exit Sub
    since Blank is just an undeclared variable in that code. ;)

    FWIW, you can distinguish between the user pressing Cancel or pressing OK with a...
  24. Replies
    8
    Views
    217

    That's not correct. While...Wend is perfectly...

    That's not correct. While...Wend is perfectly valid in VBA, if a little old-fashioned.
  25. Replies
    6
    Views
    198

    So column A and column B have the names of the...

    So column A and column B have the names of the ranges in, but are not themselves the named ranges?
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4