Jun 23, 2009 · Dim originally (in BASIC) stood for Dimension, as it was used to define the dimensions of an array. (The original implementation of BASIC was Dartmouth BASIC, which …

Oct 6, 2010 · Pardon me as am a newbie in VBA. Sometimes I use Dim r as Range r = Range("A1") Other times I use Set r = Range("A1") What is the difference? And when should I …

Jun 24, 2014 · Using Dim makes the intentions of your code explicit and prevents common mistakes like a typo actually declaring a new variable. If you use Option Explicit On with your …

Dim and Private work the same, though the common convention is to use Private at the module level, and Dim at the Sub/Function level. Public and Global are nearly identical in their …

Dec 8, 2008 · Take this example (VBA on the left | C on the right): Dim A, B As Range | Range A, B;. Going with your analogy, A = B | A = B; would be correct (and it would be in C), but Set A = …

Feb 21, 2020 · 2 Why does VBA convert a long variable type into an integer if I declare more than 2 variables at once? The following tests result in long variables in the first 2 cases, but an …

Dim i As Long Dim rows As Long Dim rng3 As Range rows = rng3.rows.Count For i = rows To 1 Step (-1) Does anyone know how this loop works? I'm confused on the meaning of rows To 1 …

Sep 24, 2016 · Dim wss as worksheets Dim ws as worksheet Set ws = thisworkbook.wss("Sheet1") but the latter just looks like I'm trying to rename/shorten …

Nov 12, 2009 · Dim fso, MyFile, FileName, TextLine declares things called 'variables' of type variant. A variable is a bit of space in memory with a name and a type. You use them to let the …

Sep 25, 2014 · VBA uses this code name to automatically declare a global-scope Worksheet object variable that your code gets to use anywhere to refer to that sheet, for free. In other …