whilst

Good morning, - as a Lotus 123 veteran (!) I still use a lot of keyboard shortcuts within Excel such as Alt+f (File) followed by c to close the active workbook. Whilst these work most of the time, sometimes they don't and the above sequence will result in a "c" appearing in the active cell, and...

Hi all, i have the below piece of code that i run every 200 milliseconds. It works fine however i am looking for a better, more efficient way of producing the same result. I use AutoHotKey to get information from Excel and quite often i will get a Callee error, i assume this is because Excel is...

Hi, i have a macro which depending on data size, can take up to 2 minutes to complete. Now ive found if whilst this is running the user gets impatient and clicks the mouse / keyboard etc.. then i get "excel not responding" -- Is there any way to prevent this? Was thinking maybe a userform box...

Afternoon all I need help with a formula. I currently have this formula: =IF(N2="","",IF(S2="Out of Scope","",IF(A2=A1,"Timesheet","New Booking"))) I need to add another couple of criteria to this formula to return a "" if there is a "Y" in cell AE2 EXCEPT if there is a "Y" in cell AF2 in...

Hopefully this makes sense, it doesn't sound possible to me. I have a number of columns E through to JG. Every 2nd column has a number (of people required) in rows 11 through to 72, some are blank on purpose. Every other column number is a price for that number of people. The number of people...

Hi, I am using Power Query with Excel 2010. If I want to check something in Excel proper whilst developing a query, I have to close the Power Query window to do this. I.e. It doesn't work like VBA editor! I find this behavior irritating - is there a way that I can navigate within Excel tabs...