Macro Examples

14

Jan'19

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

28

May'16

Print Value from Closed workbook

Last week one student sent this question over email, so sharing it now.. Hi, I am a student of Analytix …

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

Tableau Training in Delhi

All Rights Reserved. EC Analytics Consulting 2014 - 2019.

NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 886547882 | Privacy Policy

Drop us a Query

Call Us: +91 8826547882

Drop us a Query