What is the cells object?

Excel VBA for Beginners 4-The Cells Collection object for dealing with Cells
5 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€92.78
List Price:  €129.90
You save:  €37.11
£79.40
List Price:  £111.16
You save:  £31.76
CA$136.11
List Price:  CA$190.56
You save:  CA$54.44
A$154.13
List Price:  A$215.78
You save:  A$61.65
S$135.08
List Price:  S$189.12
You save:  S$54.03
HK$782.28
List Price:  HK$1,095.23
You save:  HK$312.94
CHF 90.61
List Price:  CHF 126.85
You save:  CHF 36.24
NOK kr1,085.23
List Price:  NOK kr1,519.37
You save:  NOK kr434.13
DKK kr692.01
List Price:  DKK kr968.84
You save:  DKK kr276.83
NZ$167.80
List Price:  NZ$234.94
You save:  NZ$67.13
د.إ367.19
List Price:  د.إ514.08
You save:  د.إ146.89
৳10,976.08
List Price:  ৳15,366.96
You save:  ৳4,390.87
₹8,339.52
List Price:  ₹11,675.66
You save:  ₹3,336.14
RM473.25
List Price:  RM662.57
You save:  RM189.32
₦141,842.81
List Price:  ₦198,585.61
You save:  ₦56,742.80
₨27,810.04
List Price:  ₨38,935.18
You save:  ₨11,125.13
฿3,647.70
List Price:  ฿5,106.92
You save:  ฿1,459.22
₺3,232.12
List Price:  ₺4,525.11
You save:  ₺1,292.98
B$499.21
List Price:  B$698.91
You save:  B$199.70
R1,908.54
List Price:  R2,672.04
You save:  R763.49
Лв180.65
List Price:  Лв252.92
You save:  Лв72.26
₩135,197.71
List Price:  ₩189,282.20
You save:  ₩54,084.49
₪368.63
List Price:  ₪516.10
You save:  ₪147.47
₱5,633.91
List Price:  ₱7,887.71
You save:  ₱2,253.79
¥15,144.47
List Price:  ¥21,202.86
You save:  ¥6,058.39
MX$1,659.40
List Price:  MX$2,323.22
You save:  MX$663.82
QR364.31
List Price:  QR510.04
You save:  QR145.73
P1,370.91
List Price:  P1,919.33
You save:  P548.42
KSh13,148.68
List Price:  KSh18,408.68
You save:  KSh5,260
E£4,729.52
List Price:  E£6,621.52
You save:  E£1,892
ብር5,680.63
List Price:  ብር7,953.11
You save:  ብር2,272.48
Kz83,612.74
List Price:  Kz117,061.18
You save:  Kz33,448.44
CLP$97,978.20
List Price:  CLP$137,173.40
You save:  CLP$39,195.20
CN¥722.95
List Price:  CN¥1,012.16
You save:  CN¥289.21
RD$5,921.50
List Price:  RD$8,290.34
You save:  RD$2,368.83
DA13,490.83
List Price:  DA18,887.70
You save:  DA5,396.87
FJ$226.12
List Price:  FJ$316.58
You save:  FJ$90.46
Q779.86
List Price:  Q1,091.83
You save:  Q311.97
GY$20,923.51
List Price:  GY$29,293.76
You save:  GY$8,370.24
ISK kr13,946.60
List Price:  ISK kr19,525.80
You save:  ISK kr5,579.20
DH1,013.19
List Price:  DH1,418.51
You save:  DH405.32
L1,763.34
List Price:  L2,468.75
You save:  L705.40
ден5,702.11
List Price:  ден7,983.18
You save:  ден2,281.07
MOP$805.89
List Price:  MOP$1,128.28
You save:  MOP$322.39
N$1,893.44
List Price:  N$2,650.90
You save:  N$757.45
C$3,681.15
List Price:  C$5,153.75
You save:  C$1,472.60
रु13,335.63
List Price:  रु18,670.42
You save:  रु5,334.78
S/370.84
List Price:  S/519.19
You save:  S/148.35
K382.72
List Price:  K535.82
You save:  K153.10
SAR375
List Price:  SAR525.01
You save:  SAR150.01
ZK2,522.76
List Price:  ZK3,531.96
You save:  ZK1,009.20
L461.43
List Price:  L646.02
You save:  L184.59
Kč2,350.75
List Price:  Kč3,291.15
You save:  Kč940.39
Ft36,729.02
List Price:  Ft51,422.10
You save:  Ft14,693.08
SEK kr1,071.30
List Price:  SEK kr1,499.86
You save:  SEK kr428.56
ARS$85,766.82
List Price:  ARS$120,076.98
You save:  ARS$34,310.16
Bs691.04
List Price:  Bs967.48
You save:  Bs276.44
COP$387,583.68
List Price:  COP$542,632.66
You save:  COP$155,048.97
₡50,832.34
List Price:  ₡71,167.31
You save:  ₡20,334.97
L2,468.78
List Price:  L3,456.40
You save:  L987.61
₲737,805.73
List Price:  ₲1,032,957.54
You save:  ₲295,151.80
$U3,781.90
List Price:  $U5,294.82
You save:  $U1,512.91
zł400.73
List Price:  zł561.05
You save:  zł160.31
Already have an account? Log In

Transcript

Hey guys, welcome back. So in this video, we're going to speak about the cells collection object. So the cells collection object is a collection object that allows us to deal with cells, just like the range object. However, we do that in a different way. Because instead of providing the name of the cell, like a one, a two, B, one, B two, C three, we actually provide the row number and the column number for the cell, because the intersection of a certain row and a certain column would give us a cell, right? So this is how we deal with the cells collection object.

Instead of providing the name of the cell, we actually provide the row number and the column number for the cell. Okay, so let's have an example here. So let's say I write cells and then I open in brackets, okay, and you can see here, we've got two inputs, the row index and the column index. And actually they are both optional because you can see the square brackets around them. However, we actually need to input the row index and the column index, because this is the only way to refer to a certain cell. And even though they are optional, they need they need to be inputted because if you don't input them, then you're referring to all the cells in your sheet.

So for example, if I write cells, dot select, with or without the brackets, this will actually select all the cells in my sheet as you can see here. So back to our cells collection objects. So if I write cells, one, comma two dot value equals 50. So this will actually put the value of 50 in the cell that is In the first row, and in the second column, that means is going to be cell b1. So if you run that, you can see here that cell b1 has acquired the value of 50. So basically, as you've seen here, we needed to specify which cell we needed to deal with, because the cells collection object contains all the cells.

So when you use it, if you need to deal with a certain cell, you need to actually specify which cell you are dealing with. One more thing I'd like to tell you about the cells collection object is that you're dealing with cells, just like what you were doing when you were using the range object. So actually, most of the methods and properties that we've explained when we were explaining the range object are actually going to be applicable to the cells collection object as well because at the end of the day, you're also dealing with With cells, right? So because both the range object and the cells collection object, they deal with cells, they will have the same methods and properties. Okay? So someone would ask a question here.

If the cells collection object does the same thing as the range object, which is dealing with cells, why would we bother to learn about it? So actually, in the future, when we learn about variables, which are basically containers of data, so each variable can contain some data. And this data could be a number. You could have a variable x here in the row number in the cells collection object or the row index. And this variable could have its value changing, especially if you're using a loop for example, and a loop is basically you can think about it as laps around a track or rotations or Round the track. So in the first rotation, the value of x could be one.

And then on the second rotation, the value of x could be two. And then on the third rotation, the value of x could be three, and so on and so forth. And actually, when the value of x changes, this means that you will be dealing with different cells, right? Because cells, one comma two, is different than cells, two comma two, and that's different than cells, three comma two, right? So when the value of x changes the cell that you're dealing with changes. So basically, the fact that the cells collection object except numbers, and you can plug in variables in the cells collection object, this gives it a lot of power.

And this will be clear, actually, as we progress through the course and when we reach the variable section when we explain variables, but I just wanted to highlight the power and the potential of the cells. collection object it is truly powerful. One more thing I'd like to tell you about the cells collection object is that you can actually input the column index as the column letter. So instead of inputting the number for the column, you could put the letter for the column. So for example, if I write cells, one comma C, but you actually need to write the letter in between double quotes, this will refer to cell C one. Okay?

So if I run that, you can see here that cell C one has been given the value of 50. Okay. Okay, so that's it for the introduction to the cells collection object. We will speak more about it in depth as we progress through the course. Thank you very much for watching this video and I'll see you in the next one.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.