Cybrary Pro Day is here!

4.1 Types of Macros Part 2

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

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