The below code will check each cell from the selection and highlight the cell where is a misspelled word. Sub HighlightMisspelledCells() Dim rng As Range For Each rng In ActiveSheet.UsedRange… Read more »
The following code uses VBA to open and repair the workbook (the option available using Excel Open Dialog) Sub OpenAndRepairWorkbook() Dim oWB As Workbook On Error GoTo Err_Open Set oWB… Read more »
There are many cases where we need to get the document property without the file being opened in VBA. This can be achieved by using the objects available in DSOFile.dll…. Read more »
This snippet converts the TextBoxes / Shapes with Text that are available in PowerPoint Slide to Notes Section. Sub Export_TextBoxes_AsNotes() Dim oPPT As Presentation Dim oSlide As Slide Dim oSlideShape… Read more »
A common function many people use is the COUNTIF function and that will count any value you choose. But there isn’t one function to count unique values. But we can… Read more »
Microsoft Excel and Powerpoint are perfect partners for Dynamic Tables and Dashboards. PowerPoint 2010 and PowerPoint 2013 introduced improvements to a lot of features, but sadly PowerPoint Tables was not… Read more »
PDF is always the universal format for sending the files. With lot of versions of MS Office and other Office suites around, it is always better to circulate the Deck… Read more »
For some of you this is already known, but I know there are users who are not aware of the power of the Paste Special Dialog. Suppose you have been… Read more »
Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if… Read more »
PIVOT tables are a great way to summarize data but sometimes it is important to be able to split a PIVOT table out, generating multiple reports based off all the… Read more »