Posts

VBA Modules for Excel Automation (Advance Excel)

  Essential VBA Modules for Excel Automation 1. Auto-Adjust Column Width Automatically adjust all columns to fit content. Sub AutoFitColumns() Cells.EntireColumn.AutoFit End Sub 2. Delete Blank Rows Removes all empty rows in the active sheet. Sub DeleteBlankRows() Dim rng As Range Set rng = ActiveSheet.UsedRange Dim i As Integer For i = rng.Rows.Count To 1 Step -1 If WorksheetFunction.CountA(rng.Rows(i)) = 0 Then rng.Rows(i).Delete End If Next i End Sub 3. Highlight Duplicates Highlights duplicate values in a selected range. Sub HighlightDuplicates() Dim rng As Range Set rng = Selection rng.FormatConditions.AddUniqueValues rng.FormatConditions(1).DupeUnique = xlDuplicate rng.FormatConditions(1).Interior.Color = RGB(255, 0, 0) End Sub 4. Merge Multiple Sheets into One Merges all sheets into a single sheet. Sub MergeSheets() Dim ws As Worksheet, destSheet As Worksheet Set destSheet = Sheets.Add destSh...
Post a Comment
Read more

Excel Shortcuts

  Top Excel Shortcuts & Vba 1. Basic Shortcuts Shortcut Action Ctrl + N New Workbook Ctrl + O Open Workbook Ctrl + S Save Workbook Ctrl + P Print Workbook Ctrl + Z Undo Ctrl + Y Redo Ctrl + X Cut Ctrl + C Copy Ctrl + V Paste Ctrl + A Select All 2. Navigation Shortcuts Shortcut Action Ctrl + Arrow Keys Move to the edge of data (up, down, left, right) Shift + Arrow Keys Select cells in a direction Ctrl + Home Go to cell A1 Ctrl + End Go to last used cell Page Up / Page Down Move one screen up/down Alt + Tab Switch between open applications 3. Formatting Shortcuts Shortcut Action Ctrl + B Bold Ctrl + I Italic Ctrl + U Underline Alt + H + A + C Center Align Ctrl + Shift + L Apply/Remove Filters Ctrl + Shift + % Apply Percentage Format Ctrl + Shift + $ Apply Currency Format Ctrl + 1 Open Format Cells Dialog 4. Working with Rows & Columns Shortcut Action Ctrl + Space Select Entire Column Shift + Space Select Entire Row Ctrl + Shift + "+" Insert Row/Column Ctrl + "-...
Post a Comment
Read more

PHP (Hypertext Preprocessor Notes)

  PHP Programming Notes 1. Introduction to PHP 1.1 What is PHP? PHP stands for Hypertext Preprocessor , which is a popular server-side scripting language used to create dynamic web pages. It is embedded into HTML to produce dynamic content, like interacting with databases, handling forms, and performing server-side operations. PHP is open-source and runs on most servers, like Apache and Nginx. 1.2 Syntax of PHP A PHP script starts with <?php and ends with ?> . PHP code can be embedded into an HTML file. <?php echo "Hello, World!" ; ?> 2. PHP Variables 2.1 Declaring Variables Variables in PHP are declared using a dollar sign ( $ ) followed by the variable name. <?php $name = "John" ; $age = 25 ; echo $name ; ?> 2.2 Data Types in PHP String : A sequence of characters. Integer : A whole number. Float : A decimal number. Boolean : Represents true or false. Array : An ordered collection of values. Object : An instance of a class....
Post a Comment
Read more

Java Programming

  Java Programming Notes 1. Introduction to Java Programming 1.1 What is Java? Java is a high-level, class-based, object-oriented programming language developed by James Gosling and Mike Sheridan at Sun Microsystems (now owned by Oracle). Java is platform-independent, meaning it can run on any device or operating system that has the Java Runtime Environment (JRE) installed. 1.2 Structure of a Java Program A basic Java program consists of: Class declaration : The class is the blueprint of the object. Main method : The entry point of a Java program, public static void main(String[] args) . Statements inside the main method to perform tasks. public class HelloWorld { public static void main (String[] args) { System.out.println( "Hello, World!" ); } } 2. Java Data Types 2.1 Primitive Data Types Java has eight primitive data types: byte : 8-bit integer. short : 16-bit integer. int : 32-bit integer. long : 64-bit integer. float : 32-bit floating point. d...
Post a Comment
Read more

C++ (C Plus Plus Programming)

C Plus Plus  Chapter 1 Introduction c++ is an object-oriented programming language. It was developed by Bjarne Stroustrup at AT&T Bell Laboratories in early 1980‟s. Some points:- 1. In c++, header file <iostream.h> is included. This inclusion is must because all standard functions are stored in it. 2. Complier of c++ is Turbo c++ which also support c. 3. extension of c++ program is .cpp. Object-Oriented Programing(OOP) OOP was developed to reduce the inherent limitation of traditional programming language( e.g. c, BASIC, Pascal ). Large program written in traditional programming language are complex. In OOP‟s the main emphasis is on data, not on procedure. In OOP‟s, we bundle together the data and the function that operate on the data to a single software unit called “Class”. Characteristics of OOP’s Language : - The main characteristics of OOP Language are followings:_ 1. Data Abstraction :- Data abstraction means identifying necessary information and hiding unnecessary ...
Post a Comment
Read more