Yousuf Khan has been working with the ExcelDemy project for over one year. He has written 47+ articles for the ExcelDemy site. He also solved a lot of user problems with ExcelDemy Forum. He has interests in Excel & VBA, Desktop and mobile applications, and projects & templates. He compl...
Hi, Since I have updated my PC to windows 11 Excel has not been working properly. Every 5 min the sheets seem to be unresponsive when I click on a tab or anywhere on the excel page. To make it wo... Hi Stylo9, I don't think it is a VBA problem as I don't have any...
I wrote the code below. If I run it , it works perfectly, but when I try to loop through all the worksheets in the workbook, it does not , it gets stuck on the first worksheet and keeps looping with in. I tried these methods I attached a picture of the data and a partial picture...
I have a simple macro to modify a spread sheet but it has stopped working (the F5 step-through key not responsive and the macro does not run), after I upgraded from Windows 10 to Windows 11. Who can I call to help me to resolve this problem? I opened a...
Check theEnable VBA macrosoption. PressOKtwice to close all the windows. Read More:[Solved]: Macro Settings Greyed out in Excel Case 2.2 – Create a Trusted Location SelectFileand chooseOptions. Go toTrust Center Settingsfrom theExcel Optionswindow. ...
What should I do if Autofill is not available in my Excel version? If Autofill isn't in your Excel version, you can use the fill handle, formulas, copy-paste, macros (VBA), custom lists, or third-party add-ins for similar results. It depends on your Excel version. ...
Do you have a function named "Kill" anywhere that takes a single argument not declared as a string.The VBA/FileSystem Kill function takes a variant, though normally indeed typically has no problem to accept a string variable. But try it as a variant, in the testKill macro comment the '...
How to add VBA to a recently installed Excel on Windows 11. Background: I recently bought a new machine with Windows 11. I moved most of my files from my old Windows 10 machine, including many Excel files. On my new machine, I paid for and installed Excel. Just Excel. I have no ...
Check the Trust Access to the VBA Project Object Model Create Another Excel Template Repair Corrupted Excel File 3. Why is the hyperlink file not working? If your hyperlink is suddenly not working, the reasons might be as follows: The path has been changed ...
9, 2024 dhookom Locked Solved Combine two working macros intoone for MS Word 1 meng Oct 10, 2024 VBAVisual Basic forApplications (Microsoft) Replies 7 Views 1K Oct11, 2024 strongm Locked Solved Run-time error '429': ActiveX can't createobject From Excel to ...