Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:01
So let's continue
00:03
with the slight modification of this macro.
00:06
So you see here we have selected range. See? Want to see five? And we copied it.
00:13
Now we don't want to go through this copy paste.
00:18
And then again, copy paste. We just want to copy
00:22
what we have
00:24
the values from, see? Want to see five back to see one C five. So
00:30
let's now select the range C one to see five.
00:37
Sorry,
00:40
C five,
00:42
and then we just
00:44
going to do paste values over it,
00:48
and we're just going to continue
00:52
and actually finish some.
00:56
So
00:56
we're just going to do this.
00:59
So
01:00
this is very simple. We're selecting the range, were copying it and over the same range.
01:06
You should be C one.
01:07
We are
01:11
doing pay special,
01:14
just based in values.
01:15
So we're going to close this one,
01:19
and, uh, here we have
01:25
the values only. So
01:27
I'm going to
01:30
create the function here again,
01:34
copied here so that we have functions,
01:38
and then I'm just going to press control shift in.
01:42
And now we have Well, ya's instead of formulas.
01:47
So
01:48
this is a very simple way
01:51
to play with your Mac. Rose that you have recorded. And if you're a beginner in making Mac Rose, I suggest that you do
02:01
for the recording off things you want to do, it least to start with
02:07
and to use these things to create your own mackerels, for example, the syntax off the command
02:16
that is doing
02:19
the
02:22
pasting well, ya's
02:24
is, um,
02:28
to say, the least complicated for somebody who is new in writing macros, and you should
02:34
be able to remember or all these things
02:38
so
02:39
you can just use these things.
02:42
Two.
02:43
Ah,
02:45
put them in whatever you want to do without actually having to remember all off these parameters that they needed
02:53
into
02:55
simple action or simple command in macro that Willa paste well, use only
03:05
so.
03:06
And this is the
03:07
the whole thing about recording Mac Rose and playing with them.
03:13
And you have seen
03:15
that this is,
03:16
uh, function
03:20
that is, that has Ah, this is a macro that that is defined as a subroutine.
03:27
And you, if you see these
03:30
open parenthesis, is and close parentheses here, if we need it, we could
03:37
have been able to put their some
03:40
variables
03:42
that ah can be
03:46
given to the 17 as the parameters to start working with.
03:52
But we're going to talk about that a little bit later. Maur.
03:55
So so far, this is the example off subroutine macro.

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor