When you specify a worksheet, Excel uses that worksheet instead of the Active Sheet. 'Using Code Name to specify worksheet object 'Using Worksheet Name to specify worksheet object ' PURPOSE : Show ways to use Range property 'Using Worksheet Name in the argument Here are some examples where the worksheet is specified: Sub Range_Examples_2() Just remember to put the range reference inside double quotes. Notice you can refer to multiple cells using a colon ( : ) like “A1:C3” or using a comma (, ) like “A3, B2, C1”. When you don’t specify a worksheet, Excel uses the Active Sheet in the Current Workbook. When using Range() with one argument, it must be an address string (which can include a workbook and/or worksheet name) or the name of a range.Īnd all the above refer to ranges on the Active Sheet. ' PURPOSE : Show ways to use Range property 'Write values to the Active SheetĪll of these use Range() with one argument. Here are some examples: Sub Range_Examples_1() It’s easy for most Excel users to learn Range because it looks familiar. The Range property uses cell references just like most Excel functions (e.g. Let’s look at some VBA code samples to see how it works in practice. With two arguments – like Range(“A1”, “C3”)ĭon’t worry if this theory doesn’t make 100% sense right now….With one argument – like Range(“A1:C3”).It works for single cells and multiple cells. You use this to refer to cells on the worksheet. Let’s have a look at where the Range property fits in the Excel Object Hierarchy (this is basically the language structure and how you access things in VBA):Įxcel Application > Workbook > Worksheet > RangeĮvery worksheet in Excel has a Range property in VBA. #1 – Range – refers to Single Cells or Multiple Cells They’ll help you write Excel VBA Macros better and faster. Excel VBA Cheat Sheets » Find it hard to write Excel VBA Macros? Think there’s too much to remember? You’re not alone! Check out my convenient one-page guides.

Visual basic for excel cells function