This post covers everything you need to know about using Cells and Ranges in VBA.
Sometimes it can be tricky to see which range you are dealing with when the value are all numbers.Generally speaking, you do three main things with Cells Excel has a number of methods for accessing cells such as Range, Cells and Offset. The worksheet has a Range property which you can use to access cells in VBA.The Range property takes the same argument that most Excel Worksheet functions take e.g. The following example shows you how to place a value in a cell using the Range property.Using the Cells property is useful if you are accessing a cell based on a number that may vary. The following code finds the first blank cell in the first spreadsheet row and writes text to it.In this example we have the number of the column and the row.