Register Now
You need to be registered to access all features and be part of the community.
Don't worry it's free !
Register Now
Lost Password
Lost your password? Please enter your username and email address. You will receive a link to create a new password via email.
Excel VBA Basics #9 - Declaring variables with DIM and using SET to abbreviate worksheet name :
Ratings : 59 %
Excel VBA Introduction Part 9 - Object Variables :
Ratings : 67 %
Excel VBA: How to define column in range with variable. This is a discussion on Excel VBA: How to define column in range with variable within the Excel Questions
Read More
Ratings : 54 %
VBA for Beginners - Vba Variables Explained Simply :
Ratings : 46 %
Excel VBA Introduction Part 34 - Type Declarations (User-Defined Types) :
Ratings : 20 %
VBA for Access Tutorial | How to Declare Variables and Constants | InfiniteSkills :
Ratings : 33 %
I have a variable named end_row, which returns the last row in a worksheet i.e. 5. I know I can create a range using end_row as one variable by saying(...)range = "A2:B
Read More
Ratings : 19 %
Add the following code to declare a global variable: Public myGlobalVar As String
Read More
Ratings : 30 %
.NET has spoiled us :) Your declaration is not valid for VBA. Only constants can be given a value upon application load. You declare them like so:
Read More
Ratings : 14 %
Excel VBA - Declaring Variables :
Ratings : 16 %
Excel VBA Introduction Part 25 - Arrays :
Ratings : 32 %
I'm brand new to VBA and am trying to write a macro to pull specific data from all workbooks in the same directory into a master workbook. I'm getting stuck when
Read More
Ratings : 66 %
Create a Static Array Variable in VBA and Macros in Excel :
Ratings : 31 %
Excel VBA Basics #17 To Declare Variable or Not To Declare - How To NOT HAVE TO DIM All Variables :
Ratings : 21 %
Excel VBA Introduction Part 8 - Variables :
Ratings : 18 %
How to Name and Define Variables in VBA: Quick Tutorial :
Ratings : 38 %