Forum

Hi Nicko, No file is attached. Regards Phil

Hi Angela, Have you read the article on implicit intersection that Mynda linked to? Because you are not specifying a column for INDEX to use in ...

Hi Chenise, As I said in the Helpldesk ticket you raised, we won't do your assignment for you but you are welcome to browse through our site which ...

Hi SC, Just use the formula I typed out above. See attached for examples in the worksheet and in VBA. regards Phil

Hi SC, You need at least Excel 2007 to use the WORKDAY function I'm afraid. Can you not get that? Phil

Hi SC, If your named range is Holidays then using the code I wrote should work. The sheet name doesn't matter. Please attach your workbook so I...

Hi Sharmita, You can use this =WorksheetFunction.WorkDay(Now(), -1, Range("Holidays")) where Holidays is a named range containing the date...

Hi Bill, No workbook attached. Regards Phil

Hi David, I've just seen your 2nd post. Perhaps the issue is that the other workbook is a .xlsm file? Again, without the exact error message it...

Hi David, How exactly does it not work? If you are getting an error you need to tell us what it is. When I try this code it works fine, with so...

Hi Mariya, You could use events to trigger some VBA to insert a row in the table, but I don't know how your barcode scanning works. The event will...

Hi, Do you mean the message states 'The file is locked for editing by another user'? A screenshot would be useful. Who is the other user? Ar...

Hi Robert, The 2nd and 4th conditions are No in both El Docs and UA, so how do we distinguish the difference between them to know that one has a fe...

Hi Kevin, I'm not sure what isn't working for you. Doing as Catalin suggests works fine for me e.g. If TestString Like "*#*" Then Debug.Print...

Hi Don, There's a link at the top of this page to download the course files Phil