Search results

  1. Darrell

    Solved Getting Error Intersect of Object Globad Failed

    On your Sheet3 code, I think this bit should have been If ActiveCell.Text = "DELETE" Then
  2. Darrell

    Create Excel from Access

    Yeah I thought it was an odd way of doing it but his original request was to populate multiple sheets (1 sheet per year) and so I thought he was still going down that route. This request is a bit of a moving target to be fair...
  3. Darrell

    Create Excel from Access

    OK looks you have decided to create the Workbook from scratch when the report is run. You will probably need to work out how many sheets to create based on the range of leave in your table, but I'm sure you can work that out. Gasman is right in that you are referencing the wrong object, this...
  4. Darrell

    Numbering

    Try something like this.. Sub Macro1() Dim i As Integer Dim y As Integer With ThisWorkbook.Sheets("Sheet5") .Range("D3") = "Monday" .Range("D3").AutoFill Destination:=.Range("D3:ND3"), Type:=xlFillDefault y = 4 i = 1 Do Until .Cells(2, y).Address = "$NE$2"...
  5. Darrell

    Create Excel from Access

    For what it's worth, here is a rough attempt at what you originally were looking for where the spreadsheet is updated after the Save button is clicked. I've based this on the following: - The Input form in access has: Staff ID (ie a unique number), First Name, Last Name, Leave Type, Leave Date...
  6. Darrell

    Create Excel from Access

    Just curious but what happens when you have two people with the same name..?
  7. Darrell

    The Oscars

    I'd definitely take it the wrong way and slap Greta Thunberg :D
  8. Darrell

    Copy and Paste if a criteria is met

    This might get you started. You'll need to put this in the Worksheet_Change of each sheet 2-5 Private Sub Worksheet_Change(ByVal Target As Range) Dim wReq_Sheet As Worksheet Dim sMat As String Dim iQty As Integer Dim sDesc As String Dim iLastRow As Integer Set wReq_Sheet =...
  9. Darrell

    The Slightly Obscure Music Discussion And Quizzy Thread

    I think I've found the Anti-Beato...
  10. Darrell

    The Slightly Obscure Music Discussion And Quizzy Thread

    Porcupine Tree knew
  11. Darrell

    Excel file reverts to read-only while in use

    I don't think that's the case but will check when he's back from his holiday.
  12. Darrell

    Excel file reverts to read-only while in use

    Yeah that's why I'm unsure if it's an excel specific problem. But I can be in the workbook in read only after I've selected 'Notify' (because it's told me that my colleague has it open for editing), and then sure enough about half an hour to an hour later I get a message saying that it's...
  13. Darrell

    Excel file reverts to read-only while in use

    Not really no. The only people who use these workbooks in write mode are the two of us (not at the same time of course)
  14. Darrell

    Excel file reverts to read-only while in use

    Another random problem that one of my co-workers is having is that he regularly will be working on a workbook in write mode and approx. half an hour later I'll hear him swearing and then showing me that his file has gone from write mode to read only. I've never seen this before and thankfully...
  15. Darrell

    File locked for editing but no lock file

    Hi Doc, yes we are all using the same versions and I also have my workbooks open with a choice between write and read-only so staff will only go into one in write mode by accident, which is no problem as we can tell who it is. We are using 365 yes. I guess what I need to do now is work out how...
  16. Darrell

    File locked for editing but no lock file

    That's ok I wasn't exactly sure either but what you have described is pretty much the behavior I'm seeing. What I find strange though is that there is no locking file present at all when this happens.
  17. Darrell

    File locked for editing but no lock file

    The workbook is pretty much 'stand-alone' and not linked with anything. I think I've pretty much narrowed it down to people who are using the file in read-only mode while I've had it in write mode. So when I close the workbook the locking file gets deleted, but for some reason there is a...
  18. Darrell

    Off Topic

    The guy I got mine off asked me if I was going to put it up myself, so I had to say "No, I was thinking maybe in the living room"
  19. Darrell

    Auto Sort Scores

    As Gasman states, your range is wrong to being with, but the syntax looks weird also. You really should end up with something like this Range("B5:C16").Sort Key1:=Range("C5"), Order1:=xlDescending, Header:=xlYes
Top Bottom