SOME EXCEL VBA SAMPLES

Search through a two-dimension Matrix with the VLOOKUP-Function

Jan 5, 2021
Add comment

With a user defined function, determine text, address and sub address of a hyperlink.

Dec 15, 2020
Add comment

Count only colored cells

Dec 15, 2020
Add comment

Ascertain if a File exists in a Directory

Dec 14, 2020
Add comment

VLOOKUP on a Closed Workbook

Dec 13, 2020
Add comment

Show more posts

Construct an Array Formula in VBA

Dec 13, 2020
Add comment

Auto Update Sorted List

Dec 13, 2020
Add comment

XLOOKUP FUNCTION

Dec 11, 2020
Add comment

How to Compare Two Data Ranges in Excel

Jan 30, 2018
Add comment

Convert all external links from formulas into values

Jan 5, 2018
Add comment

Extract Year from Text

Dec 28, 2017
Add comment

Hide Empty Rows on Print

Dec 24, 2017
Add comment

Create an Access File from within Excel File

Dec 23, 2017
Add comment

Sort by Frequency

Dec 15, 2017
Add comment

Conditional Formatting with VBA

Dec 14, 2017
Add comment

User Defined Function (UDF): How can I ascertain if two fields have identical Values?

Dec 14, 2017
Add comment

List Dates and Week Number

Dec 14, 2017
Add comment

How can I make Excel ask for a Start- and Enddate via an InputBox and then mark both dates colored?

Dec 14, 2017
Add comment

Array Function

Dec 14, 2017
Add comment

INDIRECT FUNCTION

Dec 13, 2017
Add comment

INDEX and MATCH Function

Dec 8, 2017
Add comment

Dynamically Refreshing Pivot Tables

Dec 6, 2017
Add comment

SAP Analysis Office on Excel

Dec 6, 2017
Add comment

 ADVANCEd   Excel                                     Access                 databases                                       VBA macros                                       SQL scripts                                       BI Reports                                         data   integrity                                          big data                                             data science                                   data mining                                     data mapping                                   data profiling                                 data   visualization                                   data modeling                                 financial     analysis                                           SCORE CARDS                                     BENCHMARKS                                     PERFORMANCE   KPI METRICS

Print Print | Sitemap Recommend this page Recommend this page
© Ray Erden

This website was created using 1&1 IONOS MyWebsite.