Recent content by Darrell

  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...
Top Bottom