Input Range Cell Coloum Macro. This tells excel to look at cell b1. How to refer to cells using vba s range object.
Sub refer range b1 end sub. Instead of writing range a2 b10 every time we can simply write the word rng. Set range in vba means we specify a given range to the code or the procedure to execute if we do not provide a specific range to a code it will automatically assume the range from the worksheet which has the active cell so it is very important in the code to have range variable set.
When applied to a range object that is a multiple area selection this property returns columns from only the first area of the range.
If you d like to follow along open a blank workbook go to the developer tab click visual basic and click insert new module. Now the variable rng refers to the range of cells from a2 to b10. Add a number to an existing number. If you d like to follow along open a blank workbook go to the developer tab click visual basic and click insert new module.
