Read more about the article VBA Operators | Performing Data Operations and Building Expressions
Complete guide to key VBA operators for performing calculations and controlling program logic.

VBA Operators | Performing Data Operations and Building Expressions

In previous tutorials, we learned about variables and constants in VBA. In this free VBA lesson, we’ll explore VBA operators and see how to perform arithmetic, comparison, and logical operations…

Continue ReadingVBA Operators | Performing Data Operations and Building Expressions
Read more about the article Data Types in VBA (with Range Table and Naming Prefixes)
Table of VBA data types with value ranges, memory usage, and variable name prefixes

Data Types in VBA (with Range Table and Naming Prefixes)

VBA supports various data types, and choosing the right one has a direct impact on execution speed, memory usage, and preventing type conversion errors.In this article, we’ll review all numeric…

Continue ReadingData Types in VBA (with Range Table and Naming Prefixes)
Read more about the article How to Convert Excel Files to PDF Using VBA?
Cover image for the tutorial post on converting Excel files to PDF using VBA macros

How to Convert Excel Files to PDF Using VBA?

Saving Excel files as PDF is a common need for users, especially when sending financial reports or official documents that should not be edited. In this post, you'll learn simple…

Continue ReadingHow to Convert Excel Files to PDF Using VBA?