Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App
Basics of VBA / Macros Chapter – 66 (Function and Sub Part-4)

27 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 66 (Function and Sub Part-4)

By default, UDF's (User Defined Functions) in Excel VBA are not volatile. They are only recalculated when any of the function's arguments change. A volatile function will be…

Read article →
Basics of VBA / Macros Chapter – 65 (Function and Sub Part-3)

25 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 65 (Function and Sub Part-3)

Below we will look at a program in Excel VBA which creates a User Defined Function that calculates the average of a randomly selected range excluding one or more…

Read article →
Basics of VBA / Macros Chapter – 64 (Function and Sub Part-2)

23 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 64 (Function and Sub Part-2)

Below we will look at a program in Excel VBA that creates a User Defined Function. Excel has a large collection of functions. In most situations those…

Read article →
Basics of VBA / Macros Chapter – 63 (Function and Sub Part-1)

21 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 63 (Function and Sub Part-1)

The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs become very useful as…

Read article →
Basics of VBA / Macros Chapter – 62 (Arrays Part-5)

19 Feb 2017 · Excel VBA · 1 min read

Basics of VBA / Macros Chapter – 62 (Arrays Part-5)

To get the size of an array in Excel VBA, you can use the UBound and LBound functions. Place a command button on your worksheet and add the following…

Read article →
Basics of VBA / Macros Chapter – 61 (Arrays Part-4)

17 Feb 2017 · Excel VBA · 1 min read

Basics of VBA / Macros Chapter – 61 (Arrays Part-4)

Below we will look at a program in Excel VBA which creates a User Defined Function that uses the Array function to return the names of the months. User…

Read article →
Basics of VBA / Macros Chapter – 60 (Arrays Part-3: Dynamic & Multi-Dimensional)

15 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 60 (Arrays Part-3: Dynamic & Multi-Dimensional)

Excel VBA Series Chapter: 60 Topic: Dynamic Arrays & ReDim Preserve \n\n When the number of data points is unknown at compile time, static arrays cannot accommodate incoming…

Read article →
Basics of VBA / Macros Chapter – 59 (Arrays Part-2)

13 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 59 (Arrays Part-2)

If the size of your array increases and you don't want to fix the size of the array, you can use the ReDim keyword. Excel VBA then…

Read article →
Basics of VBA / Macros Chapter – 58 (Arrays Part-1)

11 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 58 (Arrays Part-1)

An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index…

Read article →
Basics of VBA / Macros Chapter – 57 (Events Part-6)

9 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 57 (Events Part-6)

Below we will look at a program in Excel VBA that creates a rolling average table. Place a command button on your worksheet and…

Read article →
COUNTBLANK Function in Excel: Count Empty Cells

7 Feb 2017 · Excel Functions A–Z · 2 min read

COUNTBLANK Function in Excel: Count Empty Cells

Count the number of empty cells in a range, essential for identifying missing records, incomplete audit checklists, and data hygiene gaps.

Read article →
Basics of VBA / Macros Chapter – 56 (Events Part-5)

7 Feb 2017 · Excel VBA · 3 min read

Basics of VBA / Macros Chapter – 56 (Events Part-5)

Below we will look at a program in Excel VBA that splits an amount of money into bills and coins. Situation: Create a Worksheet…

Read article →
Older posts
Newer posts
← Previous Page1 … Page102 Page103 Page104 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →