processor

HI, I am a trader who wants to do some backtesting with excel. It went fine until yesterday. I discovered that my workbook won't finish its calculations, each time I press f9, shift+f9, ctrl+shift+f9 or change calculations mode from manual to automatic and vice versa it starts to calculate...

My hard drive crashed and now my macros will not work. I believe I need to go to Tools and References but what do I need to add for this line? Public Declare Function apiShowWindow Lib "user32" Alias "ShowWindow" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long I am running Windows 10 64...

to save wasted processing I sometimes use =if(A1="","", [heavy formula]) which clearly works, as the heavy formula isn't calculated when its redundant. But if i use IFS() to do the same (as per the below) =IFS(A1="", "", A1=0, "", 1=1, [heavy formula]) it should do the same... BUT when...

Hi folks, I'm looking to buy a SurfaceBook 2 for home and working from home. My IT person at work said I'd need at least an i7 and 16MB of RAM. A SB2 with those options is *really* pricey. I'm wondering if I can get by with an i5 and 8MB. For background, I work with Excel files that are...

One of my friend prepared some checklist where all the required staff was asked to put processor id in one column and in other the current date and time. When we double click the cell then automatically the processor id and date & time get pop up. I tried from my end but did not get any answer...

Hi all, I am a simpleton with VBA and have a question regarding dates in VBA. I have a large financial workbook with many tabs of data, and am trying to compile a management summary report. I have a "processor" tab where I run all of my macro's from. Here on the processor tab, I have the...