Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    6
    Views
    230

    You can also use the TEXT function:...

    You can also use the TEXT function:
    =CONCATENATE(TEXT(F2,"dd/mm/yyyy")," ",J2)
  2. If Ctrl+End isn't taking you past the end of your...

    If Ctrl+End isn't taking you past the end of your data (the selecting 'backwards' scenario) then you don't need to do anything. If it is, then once you've done Ctrl+Shift+End you can delete those...
  3. Replies
    3
    Views
    169

    It was chucking it down this morning, but am in...

    It was chucking it down this morning, but am in London at the moment where I can actually see blue skies! :)
  4. Replies
    8
    Views
    294

    You don't have to pay to do that.

    You don't have to pay to do that.
  5. Replies
    3
    Views
    169

    =INDEX(B1:B1000,match(MAX(A1:A1000),A1:A1000,0))...

    =INDEX(B1:B1000,match(MAX(A1:A1000),A1:A1000,0))

    would be one way.
  6. Select W259 then Ctrl+Shift+End.

    Select W259 then Ctrl+Shift+End.
  7. Usually just deleting the rows and columns below...

    Usually just deleting the rows and columns below and to the right of the actual last cell, and then saving the file will fix this.
  8. Thread: Excel Formatting

    by rory
    Replies
    7
    Views
    308

    You could just do a series of Find/Replace...

    You could just do a series of Find/Replace operations to replace "(", ")","-" and spaces with nothing.
  9. Nor am I to be honest - this would be the only...

    Nor am I to be honest - this would be the only use I can really think of! Plus, MZ Tools can add line numbers to existing code with a single button click. :)
  10. It's easier if you use line numbers in your code...

    It's easier if you use line numbers in your code - then you can simply use the erl function.
  11. Replies
    4
    Views
    216

    Like this?

    Like this?
  12. Unfortunately not, as I never figured out why it...

    Unfortunately not, as I never figured out why it worked sometimes and not others - it appears all over the various forums as an issue though, so it's not just me. ;)



    I wish someone would tell...
  13. Just as an FYI, the Shell.Popup is unreliable in...

    Just as an FYI, the Shell.Popup is unreliable in my experience in terms of dismissing itself.
  14. Surely the SDI interface removes this problem...

    Surely the SDI interface removes this problem completely as you can simply put the windows next to each other and the scrolling is independent? (and they are opening in the same instance, not a...
  15. Thread: If statement

    by rory
    Replies
    9
    Views
    276

    [SOLVED] And another option:...

    And another option:
    =If(OR(A1={17,30,38,87}),"Home","")
  16. 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?]",...
  17. Replies
    2
    Views
    95

    [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...
  18. 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?
  19. 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)?
  20. 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:...
  21. Replies
    5
    Views
    197

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

    by rory
    Replies
    21
    Views
    605

    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...
  23. Replies
    16
    Views
    1,041

    Yes, exactly that.

    Yes, exactly that.
  24. Replies
    16
    Views
    1,041

    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.
  25. Replies
    4
    Views
    208

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