Sense of  judgement

A 24 year old boy seeing out from the train’s window shouted… “Dad, look the trees are going behind!” Dad smiled and a young couple sitting nearby, looked at the 24 year Old’s childish behaviour with pity, suddenly he again…
Relationship (Importance of Gate)

किवाड़ क्या आपको पता है ? कि किवाड़ की जो जोड़ी होती है, उसका एक पल्ला पुरुष और, दूसरा पल्ला स्त्री होती है। ये घर की चौखट से जुड़े-जड़े रहते हैं। हर आगत के स्वागत में खड़े रहते हैं।। खुद…
Auto Fit Columns

Sub AutoFitColumns() ‘ Smart code for Autofit all columns of Active Worksheet ‘ Smart Excel(anilnahar.com) Cells.Select Cells.EntireColumn.AutoFit End Sub
Alphabets Serial Capital And Small Letter

Sub Alphabets_capital() ‘ Smart code for Serial Alphabets in Capital Letters from select cell ‘ Smart Excel (www.anilnahar.com) Dim i As Integer For i = 65 To 90 ActiveCell.Value = Chr(i) ActiveCell.Offset(1, 0).Select Next i End Sub ————— Sub Alphabets_small()…

Sub MulipleTextFiles() ‘SmartCode for Insert Multiple text file in worksheets ‘SmartExcel(www.anilnahar.com) Dim xFilesToOpen As Variant Dim I As Integer Dim xWb As Workbook Dim xTempWb As Workbook Dim xDelimiter As String Dim xScreen As Boolean On Error GoTo ErrHandler xScreen…
Ready to Use 101 Powerful MS Excel VBA Code

Increase Your Excel Productivity 10x :   This book is to provide basic guideline for people interested in Excel VBA programming. Collection of ready code has been used on reality platform by technical and non technical users on their routine…