Fichas
Relative Referencing
Fichas del conjunto (6)
- 1General syntax for selecting a cell using relative referencing:ActiveCell.Select
- 2General syntax for changing the value of a cell using relative referencing:ActiveCell.Value = [additional code]
- 3General syntax for moving from the active cell to another cell using relative referencing:ActiveCell.Offset(#,#).Select
- 4When we use ActiveCell.Offset(#,#).Select, the what does the offset indicate?the offset indicates how many cells up or down and how many cells to the right or left we should move from whatever the active cell is
- 5When we use ActiveCell.Offset(#,#).Select, the what does the first number indicate?- the first number indicates how many cells we should move up or down from the active cell
- if the number is positive, it means we should move down that number of cells
- if the number is negative, it means we should move up that number of cells. - 6When we use ActiveCell.Offset(#,#).Select, the what does the second number indicate?- the second number indicates how many cells we should move to the right or left
- if the number if positive, it means we should move to the right that number of cells
- if the number is negative, it means we should move to the left that number of cells.
Información
- Descripción
- Business/Economics Fichas sobre Relative Referencing, creado por Kennadie Long el 29/11/2018.
- Creado por
- Kennadie Long
- Visitas
- 0
- Valoración