Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.09 seconds.

  1. Thread: If statement

    by rory
    Replies
    9
    Views
    161

    And another option:...

    And another option:
    =If(OR(A1={17,30,38,87}),"Home","")
  2. OK then - you basically need: Dim appAc As...

    OK then - you basically need:

    Dim appAc As Access.Application

    Set appAc = GetObject(, "Access.Application")

    With appAc.DoCmd
    .SetParameter "[First Name?]",...
  3. Replies
    2
    Views
    72

    [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...
  4. 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?
  5. 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)?
  6. 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:...
  7. Replies
    5
    Views
    163

    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.
  8. Thread: Trimming VBA Code

    by rory
    Replies
    21
    Views
    383

    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...
  9. Replies
    16
    Views
    870

    Yes, exactly that.

    Yes, exactly that.
  10. Replies
    16
    Views
    870

    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.
  11. Replies
    4
    Views
    176

    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
  12. Replies
    16
    Views
    870

    Can you post the workbook with any confidential...

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

    by rory
    Replies
    21
    Views
    383

    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 =...
  14. Replies
    3
    Views
    138

    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.
  15. 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...
  16. 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.
  17. Thread: Debugging code

    by rory
    Replies
    16
    Views
    469

    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....
  18. Replies
    25
    Views
    993

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

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

    by rory
    Replies
    16
    Views
    469

    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
  20. Replies
    8
    Views
    216

    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.
  21. Replies
    8
    Views
    216

    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.
  22. Replies
    8
    Views
    216

    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.
  23. Replies
    5
    Views
    170

    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...
  24. You could use: With...

    You could use:

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

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4