Translated into English, it takes the current cell (ActiveCell) and selects the row that is one row down from the current row and in the same column. Offset clause when you record a macro using relative references: ActiveCell.Offset(1, 0).Range("A1").Select There are times when you are processing a list when you might want to look at the values in the same row, but a couple of columns over. If you are watching the sheet, the values simply appear.
This is way faster than selecting the cell, changing the value, selecting the next cell, etc. Whatever cell you were in when you entered the loop is where you are when you leave the loop. Cells works best with calculated cells, especially when you couple it with a loop: For i = 1 to 10Ĭells(i, 1).value = i ' fill A1 through A10 with the value of i To select a cell in Excel, you have two basic methods: RANGE and CELLS: Range ("A1").Select Range("RangeName").Select Cells(3, 4).Select 'Selects Row 3, Column 4, i.e.
0 kommentar(er)
