Excel Job opportunities

The candidates shall have following skills :- Good working knowledge of MS Excel & Word Good Knowledge of MS Power Point Competent in internet operation. Competent in reading and writing English. Operational knowledge of Tally/Busy will be a plus point. Educational qualification :- Preferably BCOM/BBA. BA/BSc candidates may also apply if the have skills as specified above. … Read more

Categories Uncategorized

Excel is amazing

99Excel.Com Excel is an amazing place for surfing through Excel learning and tutorials.  

Categories Uncategorized

Create individual pdf from mail merge

Create individual pdf using mail merge in word from Excel Copy + Paste below code in word file and Press F5   Sub Create_PDF_From_Mail_Merge() ‘This vba code written by Akumar – 99Excel.com Application.ScreenUpdating = False Dim DocName As String, PDFPath, Folderpath, From, Till, Message, fs Folderpath = “C:\99Excel.com – Folder” Set fs = CreateObject(“Scripting.FileSystemObject”) If fs.FolderExists(Folderpath) = False Then … Read more

Categories Uncategorized

How to return background color of cell – Vba Code resolved

Copy & paste below VBA code in your Module & use function “=CellColorIndex(A2)” in sheet.   Function CellColorIndex(InRange As Range, Optional OfText As Boolean = False) As Integer    ‘This Code created by Akumar, www.99excel.com    Application.Volatile True    If OfText = True Then    CellColorIndex = InRange(1, 1).Font.ColorIndex    Else    CellColorIndex = InRange(1, 1).Interior.ColorIndex   … Read more

Categories Uncategorized

Happy diwali

we wish you a joyous festive season with your loved ones. have a delightful diwali! 99Excel.com

How Load or unload an Excel add-in program

Click here to visit main page Click the Microsoft Office Button , and then click Excel Options. Click the Add-Ins In the Manage box, click Excel Add-ins, and then click Go. To load an Excel add-in, do the following: In the Add-Ins available box, select the check box next to the add-in that you want to … Read more

Categories Uncategorized