99Excel.Com

Best excel training institute in Delhi NCR

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

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

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

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

Live as if you were to die tomorrow; learn as if you were to live forever. G = Great A = Amazing N = Nationalist D = Daring H = Honest I = Indian

Live as if you were to die tomorrow; learn as if you were to live forever. G = Great A = Amazing N = Nationalist D = Daring H = Honest I = Indian

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

http://wp.me/p7SqRn-84