Macro Examples

14

Jan'18

HOW TO PRINT A PASCAL TRIANGLE USING VBA CODE

Problem Statement Now today we are going to create Pascal Triangle using VBA. This is not a reporting problem statement …

Read More

08

Jan'18

DIFFERENCE BETWEEN BYVAL AND BYREF-EXCEL VBA

ByRef If you pass an argument by reference when calling a procedure, the procedure access to the actual variable in …

Read More

01

Jan'18

HOW TO PRINT PYRAMID PATTERN “*” USING VBA CODE

Problem Statement Now today we are going to create pyramid using VBA. This is not a reporting problem statement but …

Read More

31

Dec'17

Find nth word from text string-EXCEL/VBA

Problem Statement Now this time we have an interesting challenge, what we want to extract is, Nth text from a …

Read More

28

Dec'17

Sort Sheets Alphabetically-Excel VBA

PROBLEM STATEMENT Sort all worksheets in A-Z/Z-A order For Example: In the below screenshot worksheets are not sorted in any …

Read More

27

Dec'17

Merging Multiple Rows based on Criteria -Excel VBA

PROBLEM STATEMENT Most of the time we deal with duplicate values in excel, same situation we have here. In our …

Read More

21

Dec'17

EXTRACT NUMBER FROM STRING – UDF

PROBLEM STATEMENT One of my student asked me this question in this weekend class, how can we extract characters from …

Read More

16

Sep'13

Crazy PMT function helps in calculating monthly EMI

PMT function is one of the financial function in excel, which calculates the periodic payment required to pay off a …

Read More

04

Sep'13

Lookup and Reference Functions – That Helped Me Keep My Job

Vlookup Function Stands for vertically lookup from the leftmost column of the table, its look for the data in the …

Read More

25

Aug'13

5 cool ways to use Conditional Formatting in Excel

If you want to pick out certain conditions met data from the huge list, conditional formatting in Excel can help …

Read More
Tableau Training in Delhi  

2012 - 2018

LOKESH@EXCELCRAZY[DOT]COM

Excel Crazy Analytics Services. All rights reserved.

NM 23, OLD DLF COLONY, SECTOR 14, GURUGRAM (DELHI - NCR) 8826547882

Drop us a Query

Call Us: +91 8826547882

Drop us a Query