This example illustrates the End property of the Range object in Excel VBA. We will use this property to select the range from the Active Cell to the last entry in a column. Situation: Some sales figures in column A. Assume that you will be adding more sales figures over time. Place a command button on your worksheet and add Read More
Category: Microsoft Office
How to Force Office Click2Run to Update
If you find a machine where the Office Click2Run is out of date, one can force the update. From an elevated command prompt, run this command: “C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe” /update user displaylevel=true forceappshutdown=true *Allow 15-30min for the process to run. **This will close the office apps (Outlook, Excel, Skype, etc)
How to Fix “Microsoft Excel is waiting for another application to complete OLE action”
Object Linking and Embedding (OLE) is a feature that allows Office applications to interact with other applications. It allows one editing application to send part of a document to other applications and then import or take it back together with other content. Common reasons for the error to pop-up are corrupted add-ins or Excel opening Read More
How to Fix Outlook Only Shows x Weeks of Email
Please check your outlook settings: Solutions 1: File account settings -> account settings from the “account settings” window select the email account Click Change Under Offline settings move the slider to the far right till it reads “all” Click Next Restart outlook Solutions 2: Change outlook into online mode instead of cached mode. File > Read More
How to Fix Outlook Default Mail Client Issue
“Either there is no default mail client or the current mail client cannot fulfil the messaging request. Please run Microsoft Outlook and set it as the default mail client.” This is a trick problem, try below two solutions. Solution 1: Delete all versions of office and install the version that you need. Looks like the Read More
Lock or Unlock Specific Areas in Excel
By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it’s possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of Read More