1
00:00:00,670 --> 00:00:06,780
And welcome back to another class, of course, about the complete introduction to VBA with Microsoft

2
00:00:06,780 --> 00:00:07,260
Excel.

3
00:00:08,670 --> 00:00:14,780
This class don't want to practice is also a little bit of programming with that Microsoft Excel.

4
00:00:15,450 --> 00:00:19,450
But what exactly they want to practice is basically in.

5
00:00:19,880 --> 00:00:22,740
Well, moving inside of your Excel document.

6
00:00:23,910 --> 00:00:29,810
So what I want to practice this because it's a huge part of VBA.

7
00:00:29,820 --> 00:00:35,430
In other words, when well, let's say you are creating your macro and you want to move from there to

8
00:00:35,430 --> 00:00:42,930
there to there to there to there will be there is a lot of movement and understanding how exactly all

9
00:00:42,930 --> 00:00:44,340
this movement works.

10
00:00:45,000 --> 00:00:46,140
It's pretty important.

11
00:00:47,100 --> 00:00:50,730
So what I'm proposing to do today is something that is pretty simple.

12
00:00:51,120 --> 00:00:58,110
And we're going to create two basic applications and learn to work with that, some well, some elements.

13
00:00:58,860 --> 00:01:02,780
So basically what we are going to learn that we put will be with that range.

14
00:01:02,800 --> 00:01:08,570
So we are going to learn how to use a range and we also going to learn how to use offsets.

15
00:01:08,620 --> 00:01:15,510
Basically, you guys have a basic level of basic knowledge about it, but what exactly I want to do

16
00:01:15,510 --> 00:01:17,230
is just practice a little bit.

17
00:01:17,550 --> 00:01:22,110
So this week, you guys will get a certain understanding of how that works.

18
00:01:22,470 --> 00:01:28,440
And you will also understand what is the difference between working with a relative reference and not

19
00:01:28,440 --> 00:01:30,750
a will and an absolute reference.

20
00:01:30,750 --> 00:01:36,540
So basically a reference means that it's always going to be generated at the same place and how you

21
00:01:36,540 --> 00:01:42,050
can write a code that will be generated as a relative reference and that will be generated as an absolute

22
00:01:42,210 --> 00:01:42,840
reference.

23
00:01:43,860 --> 00:01:44,790
So let's do it.

24
00:01:45,370 --> 00:01:52,770
So I said, what are we going to do today is just practicing how to move inside of Microsoft Excel when

25
00:01:52,770 --> 00:01:57,900
we are creating our well, when we are creating our macro.

26
00:01:58,260 --> 00:02:01,170
So first thing that I want you guys to do is very simple.

27
00:02:02,220 --> 00:02:04,790
So I want you to create yourself in modules.

28
00:02:04,790 --> 00:02:10,100
So simply go in insert and you can insert a module.

29
00:02:10,110 --> 00:02:11,690
So you can it's very emotional.

30
00:02:11,720 --> 00:02:15,150
So here I already have a module, so I'm not going to insert modules.

31
00:02:15,840 --> 00:02:22,410
And then when it's not what we want to do, this is pretty much starting out our procedure because we

32
00:02:22,410 --> 00:02:25,720
need to generate a sub procedure in this case.

33
00:02:26,310 --> 00:02:31,570
So if we want our micro works or how exactly we can read this, it's pretty simple.

34
00:02:31,590 --> 00:02:36,080
Once again, we're going to insert and we are going to generate a sub procedure.

35
00:02:36,090 --> 00:02:44,850
So we'll go for micro test and we're going to click on OK, so we have our sub procedure.

36
00:02:45,630 --> 00:02:49,470
So for the first part of the course, what I'm going to do is pretty simple.

37
00:02:50,250 --> 00:02:55,230
I want to generate the well, let's say something right there.

38
00:02:55,990 --> 00:03:01,530
So let's say I want to write down step one, then step to the START treaty and step forward and soever.

39
00:03:03,030 --> 00:03:04,860
And basically, this is exactly what I will do.

40
00:03:05,520 --> 00:03:11,430
So let's start basically how exactly can I write down step one right here?

41
00:03:11,820 --> 00:03:12,600
So pretty simple.

42
00:03:12,600 --> 00:03:18,510
It's pretty much the same way that we have done in the past few classes.

43
00:03:19,200 --> 00:03:21,090
So we'll use the active self.

44
00:03:21,090 --> 00:03:26,220
So basically we're going to write down in the act itself and we're going to use formula or once you

45
00:03:26,220 --> 00:03:28,170
want, and write down step one.

46
00:03:28,560 --> 00:03:29,550
So let's write it down.

47
00:03:30,960 --> 00:03:32,510
So it's going to be active self.

48
00:03:33,010 --> 00:03:39,990
So in the active so that we are on we are going to write down.

49
00:03:42,590 --> 00:03:44,220
Or a movie

50
00:03:46,900 --> 00:03:48,480
or one sequel.

51
00:03:49,540 --> 00:03:54,700
That's basically what we have learned, this is the function or the element that we are going to use

52
00:03:55,480 --> 00:03:57,880
to be able to write down our text.

53
00:03:57,880 --> 00:04:00,410
So we have learned this in the past few places.

54
00:04:01,720 --> 00:04:07,480
So when it's done, we'll do we are going to write down the text that we want to write them.

55
00:04:09,670 --> 00:04:14,740
So let's say I want to write down step one in this case or just write down step one.

56
00:04:16,180 --> 00:04:16,480
Good.

57
00:04:16,960 --> 00:04:20,520
So right now I have everything that one just put it in one word.

58
00:04:20,890 --> 00:04:24,730
So if I run my app, my step one is right there.

59
00:04:24,880 --> 00:04:25,810
So pretty simple.

60
00:04:28,210 --> 00:04:29,300
Next thing that I want to do.

61
00:04:29,830 --> 00:04:30,550
Pretty simple.

62
00:04:30,940 --> 00:04:35,560
Let's say I want to make inside of my Excel spreadsheet.

63
00:04:36,070 --> 00:04:41,850
So in the case that I want to know how exactly I can inside of my Excel spreadsheets.

64
00:04:41,900 --> 00:04:42,580
In this case.

65
00:04:42,580 --> 00:04:49,860
Well, here at this particular moment, what's happening is that I want to have a relative reference.

66
00:04:49,870 --> 00:04:53,320
So basically what I will use will use the upset function.

67
00:04:54,370 --> 00:04:58,690
So once again, we are going to start our writing with the same thing.

68
00:04:58,720 --> 00:05:03,610
So we are going to start with Active Cell because we are going to move from our active cell that is

69
00:05:03,610 --> 00:05:07,660
right there and where exactly we want to.

70
00:05:08,020 --> 00:05:09,280
So let's say we want to move.

71
00:05:09,880 --> 00:05:13,710
I don't want to move from three cells, so one to three.

72
00:05:14,260 --> 00:05:16,560
So this is exactly what we are going to write down.

73
00:05:16,630 --> 00:05:17,030
All right.

74
00:05:17,040 --> 00:05:17,800
Don't upset.

75
00:05:18,970 --> 00:05:29,140
So we want to and in this case, we want to move from three steps and then will be arranged to basically

76
00:05:29,140 --> 00:05:33,660
arrange will be all this will be the spreadsheet.

77
00:05:33,660 --> 00:05:35,320
So we're going to use eight one.

78
00:05:36,550 --> 00:05:37,480
So write it down.

79
00:05:37,480 --> 00:05:41,950
Write this to arrange in this case, it will be a one.

80
00:05:44,680 --> 00:05:53,500
And you want to select the cell in which we are going to simply write down, not select go.

81
00:05:54,880 --> 00:05:57,810
But so all right.

82
00:05:58,030 --> 00:05:59,270
So we have everything that we need.

83
00:05:59,860 --> 00:06:04,350
So I know what happened is that we moved from here to one to three.

84
00:06:04,630 --> 00:06:08,660
So you understand the basics of moving inside of your Excel spreadsheet.

85
00:06:09,200 --> 00:06:09,450
Right.

86
00:06:09,470 --> 00:06:13,420
So we have got our second element.

87
00:06:13,690 --> 00:06:15,780
What to do right there is pretty simple.

88
00:06:15,790 --> 00:06:19,120
Let's say we want to write down step two.

89
00:06:19,930 --> 00:06:21,910
So pretty much the same thing.

90
00:06:22,600 --> 00:06:24,690
We are going to write down step two.

91
00:06:24,700 --> 00:06:27,150
So we are selecting our cell at first.

92
00:06:27,160 --> 00:06:32,410
So we are going to write down selection and then what exactly we're going to use.

93
00:06:32,410 --> 00:06:35,620
We are going to use formula or one, see what

94
00:06:39,100 --> 00:06:42,520
they will do and what we'll write down a simple step two.

95
00:06:48,150 --> 00:06:53,880
So if we decide to run our macro right now, what's going to happen is that it will right down step

96
00:06:53,880 --> 00:06:58,210
one there and three cells on the right and right down, step two.

97
00:06:58,740 --> 00:07:00,670
So as you can see, this is exactly what happened.

98
00:07:00,690 --> 00:07:03,390
If I run my macro, it's going to spike from here.

99
00:07:03,400 --> 00:07:09,250
So it will right down step one there from three cells and right down step two on the third cell.

100
00:07:09,780 --> 00:07:12,570
So, again, can see it's pretty simple to understand.

101
00:07:13,890 --> 00:07:16,750
So let's continue practicing it a little bit more.

102
00:07:17,430 --> 00:07:20,840
So let's say I want to move it down.

103
00:07:20,850 --> 00:07:23,250
So right now I want to move it down of three cells.

104
00:07:23,670 --> 00:07:26,630
How exactly do this so pretty simple.

105
00:07:26,640 --> 00:07:29,220
I will use the same formula that is right there.

106
00:07:29,220 --> 00:07:36,020
I will start with my active cell and I will use the offset function in the range, each one.

107
00:07:36,030 --> 00:07:38,460
So I want to move three cells down.

108
00:07:38,470 --> 00:07:40,270
So it's going to be three and then zero.

109
00:07:40,860 --> 00:07:46,880
So just select my function right there because I will use it here.

110
00:07:47,610 --> 00:07:52,610
But right now, instead of moving three steps on the side, I wouldn't three steps down.

111
00:07:52,920 --> 00:07:54,620
So I will write it this way.

112
00:07:59,100 --> 00:08:01,800
All right, so what I will do when what I have.

113
00:08:02,100 --> 00:08:05,960
So right now what I want this function says it's pretty simple.

114
00:08:05,970 --> 00:08:11,280
It says that we are going to move from here to basically there and what exactly we want to do there.

115
00:08:11,910 --> 00:08:13,560
We want to write down step three.

116
00:08:14,670 --> 00:08:18,390
So we're going to reuse this formula right there to write down step three.

117
00:08:18,750 --> 00:08:19,660
So pretty simple.

118
00:08:20,970 --> 00:08:21,480
Here we go.

119
00:08:24,480 --> 00:08:27,630
And here we are going to write down step three.

120
00:08:29,640 --> 00:08:31,930
So basically, you get a little bit at that point.

121
00:08:32,340 --> 00:08:37,290
So if we run out, what's going to happen will have stuck on there one to three.

122
00:08:37,290 --> 00:08:38,000
Step two there.

123
00:08:38,280 --> 00:08:39,690
And one, two, three.

124
00:08:39,720 --> 00:08:40,790
And step three there.

125
00:08:40,810 --> 00:08:44,060
So it will look something like this if that's going to happen.

126
00:08:44,110 --> 00:08:48,270
Step one, step two or step three, which is pretty cool.

127
00:08:49,920 --> 00:08:50,350
All right.

128
00:08:51,150 --> 00:08:52,620
Next thing that we want to do.

129
00:08:53,220 --> 00:08:59,920
So if you guys, for example, if you see here that my text is an italic, it's simply because my self

130
00:09:00,380 --> 00:09:01,560
and it's bold.

131
00:09:01,560 --> 00:09:04,130
It's not because I have written this in the code.

132
00:09:05,100 --> 00:09:07,350
So I'll just select everything that I have there

133
00:09:10,170 --> 00:09:11,730
and I'll take away all the Italian.

134
00:09:14,430 --> 00:09:15,680
So let's come back.

135
00:09:16,590 --> 00:09:16,820
Great.

136
00:09:17,370 --> 00:09:19,720
So right now we have everything that we need.

137
00:09:20,070 --> 00:09:23,090
So last thing that I want to I want to practice that.

138
00:09:23,170 --> 00:09:28,590
Let's say I want to arrange that is on the side as well as Delp.

139
00:09:29,280 --> 00:09:31,320
So right now, let's say I'm somewhere.

140
00:09:31,320 --> 00:09:31,710
I don't know.

141
00:09:31,710 --> 00:09:33,630
Let's just delete all this.

142
00:09:33,910 --> 00:09:42,060
Let's say I am right there and I want to move two steps there, about three steps, then three steps

143
00:09:42,060 --> 00:09:42,470
down.

144
00:09:43,050 --> 00:09:45,190
But now let's say I want to go right there.

145
00:09:45,210 --> 00:09:47,030
So how exactly can I do this?

146
00:09:47,050 --> 00:09:47,850
So pretty simple.

147
00:09:48,090 --> 00:09:51,750
I will simply move two steps on the side and two steps down.

148
00:09:51,900 --> 00:09:52,780
So pretty simple.

149
00:09:53,430 --> 00:09:53,930
Same thing.

150
00:09:53,940 --> 00:09:56,310
If when want to come back for for example, move back.

151
00:09:56,520 --> 00:09:59,730
What I will do, I will simply write down minus the key.

152
00:10:00,240 --> 00:10:03,180
So in this case, let's say we want to move back.

153
00:10:03,870 --> 00:10:07,470
So pretty simple how exactly will write it down.

154
00:10:07,500 --> 00:10:10,810
So we are going to reuse this formula right there.

155
00:10:13,530 --> 00:10:16,190
So the first thing we want to know where exactly we want to.

156
00:10:16,800 --> 00:10:22,200
So let's say we have made three steps down, let's say when I go to steps up.

157
00:10:22,380 --> 00:10:30,180
So we're going to write down minus two and let's say we want to go at five steps on the other side completely.

158
00:10:30,210 --> 00:10:32,670
So it's going to be minus five in this case.

159
00:10:33,330 --> 00:10:34,590
And why exactly?

160
00:10:34,590 --> 00:10:37,720
We want to write we want to write less steps.

161
00:10:37,720 --> 00:10:44,970
So we are going to reuse this formula right there to write down less step, less step.

162
00:10:47,250 --> 00:10:51,570
And what we can do right now is simply everything to be sure that it works fine so we can see everything

163
00:10:51,570 --> 00:10:54,370
works fine if we check out our code.

164
00:10:54,630 --> 00:10:57,110
So the first step was simply writing down step one.

165
00:10:57,300 --> 00:10:58,020
We have it there.

166
00:10:58,500 --> 00:11:02,120
Then the second step is moving two steps on the side.

167
00:11:02,130 --> 00:11:06,510
So I'll just do it the right way so you guys understand it a little bit more.

168
00:11:08,010 --> 00:11:09,420
So let's try it out.

169
00:11:10,500 --> 00:11:13,080
So first step is writing down step one.

170
00:11:14,080 --> 00:11:17,860
So we've done the same step will be moving two steps on the side.

171
00:11:17,890 --> 00:11:20,180
This is exactly what happening, what's happening right there.

172
00:11:20,190 --> 00:11:21,830
So we have two steps on the side.

173
00:11:22,560 --> 00:11:24,520
Next step running down, step two.

174
00:11:24,810 --> 00:11:26,030
So we have it right there.

175
00:11:26,520 --> 00:11:29,340
Then we want to move three steps down again.

176
00:11:30,420 --> 00:11:31,590
So this is what's happening.

177
00:11:31,960 --> 00:11:34,670
And the next step will be writing down step three.

178
00:11:34,890 --> 00:11:36,340
So we write down step three.

179
00:11:36,750 --> 00:11:42,960
Now we are going to move two steps and two steps up and five steps in the back.

180
00:11:44,010 --> 00:11:47,970
So this is what happened when two steps up and five steps in the back.

181
00:11:47,970 --> 00:11:50,200
And we're going to write down the last step.

182
00:11:50,220 --> 00:11:51,660
And this is exactly what happened.

183
00:11:52,050 --> 00:11:58,260
And this is basically how we are going to write down our function in Excel.

184
00:11:58,260 --> 00:12:03,990
So you can see it's pretty simple what not to write down our function, but how we can in Microsoft

185
00:12:03,990 --> 00:12:05,750
Excel with the use of VBA.

186
00:12:05,770 --> 00:12:07,610
So as you can see, it's not that complicated.

187
00:12:07,980 --> 00:12:09,960
So you said that you guys move to a certain self.

188
00:12:10,260 --> 00:12:12,240
You can add a formal function.

189
00:12:12,240 --> 00:12:16,860
You can add I don't know, for example, you want to make text bold if you want to add a certain function,

190
00:12:16,870 --> 00:12:19,390
if you can do whatever you guys want.

191
00:12:19,710 --> 00:12:21,240
But again, it's pretty simple.

192
00:12:21,250 --> 00:12:28,730
So this is how we right now, let's say you guys want to work with specific cells or in this case with

193
00:12:29,220 --> 00:12:30,570
absolute references.

194
00:12:31,470 --> 00:12:33,600
So how exactly we do this?

195
00:12:34,080 --> 00:12:35,940
So it's pretty simple.

196
00:12:36,010 --> 00:12:43,890
And instead of using the range that well, instead of using the range, how we are using it, when we're

197
00:12:43,890 --> 00:12:46,080
going to use it in a little bit different way.

198
00:12:46,110 --> 00:12:49,530
So first thing that we are going to do, we're going to create another module.

199
00:12:49,950 --> 00:12:52,800
So we'll simply ask you guys to create another module.

200
00:12:52,930 --> 00:12:53,490
You personally?

201
00:12:53,490 --> 00:12:57,180
I have another one right there and we're going to create another.

202
00:12:57,570 --> 00:12:58,660
And so pretty simple.

203
00:13:00,330 --> 00:13:06,990
We'll go back in and we're going to insert our procedure to be able to generate this procedure, so

204
00:13:06,990 --> 00:13:09,900
we'll call it what we call it.

205
00:13:09,900 --> 00:13:12,420
We'll call it the test tube.

206
00:13:13,290 --> 00:13:14,520
And we will click on.

207
00:13:14,760 --> 00:13:16,310
OK, great.

208
00:13:16,400 --> 00:13:19,910
So right now, we have our second micro mystery.

209
00:13:19,950 --> 00:13:22,760
What we're going to practice is pretty much the same thing.

210
00:13:23,100 --> 00:13:31,630
But instead of having a well of weapons, we're going to have an absolute reference.

211
00:13:31,650 --> 00:13:38,820
This means that whatever we are doing, exurbia will always work on some specific cells.

212
00:13:39,540 --> 00:13:46,440
So basically, it's not going to automatically move from one to another and adapt to where which cell

213
00:13:46,470 --> 00:13:47,230
we have selected.

214
00:13:47,580 --> 00:13:48,300
So very simple.

215
00:13:49,590 --> 00:13:51,690
So basically, how exactly do you want to start?

216
00:13:52,080 --> 00:13:58,020
So let's say we want to start by writing down something in our active cell that is there.

217
00:13:59,040 --> 00:14:00,430
So this is exactly what we'll do.

218
00:14:01,050 --> 00:14:06,270
We are going to write down in our active cells so that our active cell we're going to I don't suspect.

219
00:14:08,190 --> 00:14:09,600
So how exactly we do this?

220
00:14:09,780 --> 00:14:10,320
Pretty simple.

221
00:14:10,320 --> 00:14:13,810
We're going to reuse the same formula that we have used in our past class.

222
00:14:13,860 --> 00:14:19,110
So basically, we are going to write down active cell and in our active cell we are going to write down

223
00:14:19,150 --> 00:14:20,170
or Pueblo.

224
00:14:22,170 --> 00:14:23,170
So pretty simple.

225
00:14:23,190 --> 00:14:24,150
Let's do it.

226
00:14:25,770 --> 00:14:26,790
So active

227
00:14:30,040 --> 00:14:31,830
in this case cell.

228
00:14:40,500 --> 00:14:44,280
Or one see, one day here, it is great.

229
00:14:45,480 --> 00:14:47,190
So what is that right down there?

230
00:14:47,230 --> 00:14:48,510
Why don't step?

231
00:14:55,990 --> 00:14:56,920
Step one.

232
00:14:57,430 --> 00:14:58,540
All right, great.

233
00:15:00,520 --> 00:15:06,010
So basically what's going to happen right now is pretty simple if we run our function.

234
00:15:11,530 --> 00:15:13,990
Let's come back there if we're on it.

235
00:15:14,010 --> 00:15:17,190
What's going to happen is that right down step right there.

236
00:15:17,200 --> 00:15:22,300
But if we are mouse, what's going to happen is that it will still with it.

237
00:15:22,360 --> 00:15:26,580
So basically, we still have a function and step up.

238
00:15:26,590 --> 00:15:32,970
But if we want to look our step one in a specific cell, what we need to do, we need to specify the

239
00:15:32,970 --> 00:15:34,070
range at first.

240
00:15:34,080 --> 00:15:35,900
And this is exactly what we'll do right now.

241
00:15:36,430 --> 00:15:37,860
We want to specify the range.

242
00:15:38,250 --> 00:15:40,040
So this is what we haven't done.

243
00:15:40,950 --> 00:15:51,090
So let's say we want to write down our step one in, I don't know, the keys at the peak, so let's

244
00:15:51,090 --> 00:15:51,610
write it down.

245
00:15:51,630 --> 00:15:58,680
So basically, we're starting out with the free range and in this case, our range will be in the eight.

246
00:15:59,340 --> 00:16:06,000
So the eight will be the cell where we are going to write down our function in this case.

247
00:16:07,140 --> 00:16:14,660
So how exactly where you will write down range, each will be acceptable at it and then select this

248
00:16:14,670 --> 00:16:14,850
one.

249
00:16:14,890 --> 00:16:16,020
So basically, that's silly.

250
00:16:16,740 --> 00:16:23,700
So what's going to happen is Excel is going to select this place, is going to select the eight and

251
00:16:23,700 --> 00:16:26,400
then it will write down step one.

252
00:16:26,430 --> 00:16:28,620
So if we run our function, what's going to happen?

253
00:16:28,620 --> 00:16:32,100
As you can see, it's going to write down the function at the end.

254
00:16:33,150 --> 00:16:36,420
So even if I'm somewhat right there, what will happen?

255
00:16:37,060 --> 00:16:38,320
Pretty much the same thing.

256
00:16:38,380 --> 00:16:42,660
So it will move back here and it will write down our function at the end.

257
00:16:43,260 --> 00:16:44,490
So pretty simple.

258
00:16:45,000 --> 00:16:47,820
So right now, let's practice what we have just learned.

259
00:16:47,880 --> 00:16:54,090
So if we want to do pretty much the same thing, so instead of using a relative reference and using

260
00:16:54,300 --> 00:17:02,060
that function, we need to use we will have to use in this case, we will need to specify each time

261
00:17:02,820 --> 00:17:10,200
what what's the exact cell in which we want to write down our function or the text or whatever we want.

262
00:17:11,220 --> 00:17:19,380
So let's say the second step will be writing, going to the cell, I don't know, creating and writing

263
00:17:19,380 --> 00:17:20,290
down step two.

264
00:17:20,310 --> 00:17:26,560
So basically what we can do is simply reuse our formula because it's pretty much the same thing.

265
00:17:27,020 --> 00:17:29,640
So in our second cell right there.

266
00:17:29,670 --> 00:17:31,610
So it's going to be 18.

267
00:17:32,400 --> 00:17:34,470
We are going to write down step two.

268
00:17:35,640 --> 00:17:41,560
And if we run our text, well, if we're micro, as can see, pretty much the same thing.

269
00:17:41,580 --> 00:17:43,410
So it goes from step one to step two.

270
00:17:43,680 --> 00:17:50,180
If we wanted to write it down in a relative reference, what would what would happen is that we will

271
00:17:50,520 --> 00:17:55,650
what we would except the formula are once you one, basically.

272
00:17:55,650 --> 00:17:55,920
Right.

273
00:17:55,920 --> 00:18:02,400
They would start started there and then we would have to move from one to three cells there.

274
00:18:02,400 --> 00:18:07,330
And then one, two, three, four, five, six, seven, eight, nine, 10 cells don't.

275
00:18:08,040 --> 00:18:13,530
So this would be the same thing if we wanted to write it down in reference.

276
00:18:13,530 --> 00:18:18,110
We basically to write want to use absolute references.

277
00:18:18,120 --> 00:18:19,320
It's like this.

278
00:18:20,370 --> 00:18:25,920
So let's say I want to add a little something basic because it's possible to add some basic things.

279
00:18:25,920 --> 00:18:28,370
Let's say I want to make my second step.

280
00:18:29,790 --> 00:18:31,110
So how exactly I will do this.

281
00:18:31,110 --> 00:18:31,980
So it's very simple.

282
00:18:32,220 --> 00:18:39,170
I will simply write down selection and in this case I will use the font and I want to make it.

283
00:18:41,850 --> 00:18:42,740
So here we go.

284
00:18:44,430 --> 00:18:46,300
And basically, I want it to be true.

285
00:18:50,510 --> 00:18:53,540
If we want everything so as you can see, step two became.

286
00:18:55,070 --> 00:18:56,640
So it's pretty much the same.

287
00:18:57,050 --> 00:18:59,620
The way it works is pretty much the same thing as the.

288
00:19:00,510 --> 00:19:07,430
The only difference between the absolute reference and reference from a clothing perspective is that

289
00:19:07,430 --> 00:19:12,230
in relative reference, as you can see there, what we're going to use when he was the upset function,

290
00:19:12,230 --> 00:19:16,840
basically to move from one cell, another cell, which makes a lot of sense, because what we want to

291
00:19:16,850 --> 00:19:21,310
do is simply knowing how many cells we need to move on the right, on the left or whatever.

292
00:19:22,190 --> 00:19:30,500
And in the absolute reference way, what's going to happen is that instead we are going to select the

293
00:19:30,500 --> 00:19:35,280
exact cell in which we want to work one cell where range of cells.

294
00:19:35,280 --> 00:19:37,340
So basically it can be more than one cell.

295
00:19:38,540 --> 00:19:40,640
So hope you guys right now understand the differences.

296
00:19:40,760 --> 00:19:47,630
And I hope that right now you guys will be able to move across your Excel spreadsheet simply by using

297
00:19:48,070 --> 00:19:50,070
VBA programming language.

298
00:19:50,390 --> 00:19:52,340
So it's a first class game and you all know it.

299
00:19:52,370 --> 00:19:53,660
Next class.