Download "Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]"

"videoThumbnail Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]

Les 3 Objets Range INDISPENSABLES de VBA [#23 FORMATION EXCEL VBA COMPLETE]

Les 3 Objets Range INDISPENSABLES de VBA [#23 FORMATION EXCEL VBA COMPLETE]

Channel: Excel Formation

Tout sur les procédures Function en VBA [#07 FORMATION EXCEL VBA COMPLETE]

Tout sur les procédures Function en VBA [#07 FORMATION EXCEL VBA COMPLETE]

Channel: Excel Formation

C'est quoi VBA ? [#01 FORMATION VBA EXCEL COMPLETE]

C'est quoi VBA ? [#01 FORMATION VBA EXCEL COMPLETE]

Channel: Excel Formation

Activer VBA en affichant le menu DÉVELOPPEUR sur EXCEL [#02 FORMATION EXCEL VBA COMPLETE]

Activer VBA en affichant le menu DÉVELOPPEUR sur EXCEL [#02 FORMATION EXCEL VBA COMPLETE]

Channel: Excel Formation

Benchmarking et optimisation des variables VBA [#05.1 FORMATION EXCEL VBA COMPLETE]

Benchmarking et optimisation des variables VBA [#05.1 FORMATION EXCEL VBA COMPLETE]

Channel: Excel Formation

Comment lancer une macro VBA (13 méthodes !) [#08 FORMATION EXCEL VBA COMPLETE]

Comment lancer une macro VBA (13 méthodes !) [#08 FORMATION EXCEL VBA COMPLETE]

Channel: Excel Formation

OUBLIEZ RECHERCHEV() ! LA FONCTION INDEX-EQUIV POUR RÉALISER DES RECHERCHES COMPLEXES SUR EXCEL

OUBLIEZ RECHERCHEV() ! LA FONCTION INDEX-EQUIV POUR RÉALISER DES RECHERCHES COMPLEXES SUR EXCEL

Channel: Excel Formation

excelformation.fr

formation excel

didacticiel excel

excel

tuto

cours

gratuit

formation

débutant

copier et coller des cellules en vba avec le presse-papier

copier

coller

cellules

presse-papier

découverte de la gestion des cellules en vba

vba

copier une cellule

cellule

comment copier les cellules

dupliqué

cellules copiées

copiées

couper une cellule

couper

cut

coller des cellules

paste

dupliquer

pastespecial

opération

transpose

intervertissons

intervertir lignes et colonnes

00:00:02

in this new part of our

00:00:04

chapter on the discovery of the jso

00:00:05

hiding bba

00:00:06

we will now see how to

00:00:08

automatically carry out

00:00:09

copy and paste using macros

00:00:11

command a baby in fact this is about

00:00:12

one of the possibilities offered by bba

00:00:14

which allows extremely powerful actions to be carried out

00:00:16

in a

00:00:17

completely automated manner which will

00:00:19

therefore lead to a very significant saving of time

00:00:20

in the case of carrying out

00:00:22

daily tasks as usual,

00:00:24

emergency support is available

00:00:25

in the description of the video

00:00:30

[Music]

00:00:32

as usual you can download

00:00:34

the relief sport by following the link

00:00:36

that other males description of my

00:00:37

videos and games you are strongly to

00:00:39

download it in order to be able to carry out the

00:00:41

operations at the same time as me in

00:00:43

first of all we will see how to

00:00:44

very simply copy cells to another

00:00:47

place in the same spreadsheet

00:00:48

so for this we have here a certain

00:00:50

number of cells that we have

00:00:51

selected and these have the

00:00:53

value therefore the result given by the

00:00:55

random function between terminal therefore

00:00:57

allows us to generate a random number

00:00:59

between 1 and 10 to copy the

00:01:01

cells that we have selected, it is

00:01:03

simply enough to call them

00:01:04

as we saw in the

00:01:05

previous part thanks to the office

00:01:07

selection which is therefore an orange object

00:01:10

which corresponds to the set of cells

00:01:11

which are selected by the user

00:01:13

then to copy these cells we

00:01:15

simply have to use the

00:01:16

copy method to make sure we

00:01:19

just have to launch this procedure and we

00:01:22

will now see that our cells

00:01:23

are identified as being copied to

00:01:25

the clipboard by the

00:01:27

dotted frame which is movable around the

00:01:29

selection then to paste these cells

00:01:31

another place simply

00:01:33

select the cell on which

00:01:35

we want to copy these cells where by

00:01:37

example here just below the cell

00:01:39

at 39 to select this cell

00:01:42

so we use the select and finally

00:01:44

to copy the cells so on this

00:01:46

new cell that we are going to

00:01:47

select

00:01:48

we are now going to use the

00:01:50

past property of the active object [ __ ]

00:01:53

it is say on the spreadsheet

00:01:55

currently working then we are going to

00:01:56

start the procedure so for example by

00:01:58

pressing the f5 key and we are going to

00:01:59

see that the cells that we had

00:02:01

selected here have now been

00:02:02

duplicated so obviously if we

00:02:05

look at the result the cells

00:02:06

sources and cells that we have

00:02:07

pasted the result is not the same this

00:02:09

comes from the fact that we use the

00:02:11

formula go between port and the

00:02:12

particularity of this formula and that the

00:02:14

result which will be sent will be

00:02:16

totally different each time

00:02:17

we we are going to call this function and if

00:02:19

we want exactly the same

00:02:21

result, we simply have to perform a

00:02:23

copy then a paste by value so

00:02:27

the new one we will carry out with the mouse but

00:02:29

we will see right after how to

00:02:30

achieve this directly in vba

00:02:33

as we do we have seen here now

00:02:35

we no longer have the function go

00:02:37

between barney directly the

00:02:38

numerical values which correspond to the

00:02:39

results that we had just before

00:02:41

now we are going to restart the

00:02:42

procedure

00:02:43

and as you can see we

00:02:45

now have exactly the same

00:02:46

result

00:02:47

so obviously here we we have carried out

00:02:49

a copy and paste but we could

00:02:51

just as easily carry out a cut and paste,

00:02:53

that is to say that the source or

00:02:55

world cells are moved to the destination location

00:02:57

and for this we will

00:02:59

simply use the cut method

00:03:01

instead of copy methods that we had

00:03:02

just before we restart the procedure

00:03:05

is indeed the cells will

00:03:06

now be moved to be able to

00:03:08

return to the original situation

00:03:09

we will carry out the

00:03:10

opposite operation that is to say that we will

00:03:12

now select the cell at 33

00:03:15

after having carried out the cutting and so

00:03:18

we cells will go back to the level where

00:03:20

we had it just before so if we

00:03:22

go back to the method that we had

00:03:23

before it was the copy method we

00:03:25

saw that to carry out the

00:03:26

copy and paste we entered three

00:03:29

lines of code but we could also do

00:03:31

this directly in a single line

00:03:33

using the argument of the copy method

00:03:35

which is the destination argument which

00:03:38

allows us to directly specify

00:03:40

the place where we wish to carry out

00:03:42

the copy paste so obviously

00:03:44

this is what we wish to carry out on the

00:03:46

cell at 39 therefore select the

00:03:48

lines of code which are no longer useful

00:03:50

and restart the procedure

00:03:52

and we will see that now our

00:03:54

cells or head directly copied

00:03:55

so sometimes we will

00:03:57

only have a

00:03:58

partial paste of the source cells.

00:04:00

that is to say that we will want for

00:04:01

example to recover only the values

00:04:03

only the cetera format and therefore for

00:04:05

this we will now see an

00:04:06

example so to use the

00:04:09

partial paste we will use the

00:04:10

special past method so as before

00:04:12

we start with selects the

00:04:14

cells that interest us then we are

00:04:15

going to copy them then we are going to

00:04:17

select the cell on which

00:04:18

we want and vehicles collage

00:04:20

so not a flat cell at 39 and on

00:04:22

this one we are going to call the

00:04:24

past special method so by default this one has

00:04:26

in four arguments

00:04:27

the vast argument white ski operation

00:04:30

and transpose therefore the first allows us to

00:04:33

define the type of paste that we

00:04:34

wish to carry out and when we launch

00:04:36

just before we are going to want to

00:04:37

carry out a college

00:04:39

two values so we are going to insert the

00:04:41

value xl pastebin use so here

00:04:43

necessarily if we launch the procedure

00:04:45

we will not see the difference given that here the formatting is

00:04:48

exactly the same name but imagine

00:04:50

that we have here yellow cells

00:04:53

here green cells and that we

00:04:56

delete for example the values that

00:04:58

we have here we we can

00:05:01

select the original cells again

00:05:03

and when we now

00:05:04

restart the procedure we will see

00:05:06

that the values have been copied but that

00:05:08

the formatting the slope has remained

00:05:09

unscathed

00:05:10

then we will have the

00:05:12

humant seeder which is the operation argument which

00:05:14

allows this time to define an

00:05:16

operation carried out when we are going to

00:05:18

carry out the copy paste for example

00:05:20

we can use the xl past special

00:05:23

operation had which will consist of

00:05:25

adding the values copied to the

00:05:27

values which are already in the

00:05:29

destination cell so we

00:05:31

select again the original cells and

00:05:33

here we have seen we are going to

00:05:35

use the xl not this special operation

00:05:39

adha we launch the procedure and we

00:05:41

will see that the values will

00:05:43

now be doubled another

00:05:45

interesting point of this argument therefore which

00:05:47

allows us to carry out operations

00:05:48

is that we cannot a fold

00:05:50

carry out a multiplication

00:05:52

using the multiplied and when the

00:05:55

original cell will have the value - 1

00:05:57

then when we are going to launch the

00:05:58

procedure automatically this will

00:06:01

allow us to change the direction of the

00:06:03

cell on which we we will apply the paste the ski

00:06:05

blank argument allows us to override

00:06:07

empty cells, that is to say that if

00:06:09

in our selection certain cells

00:06:11

have no value then these

00:06:12

will not be taken into account during the

00:06:14

paste so here we will give

00:06:16

this argument the value of holes and

00:06:18

then the last argument which is

00:06:20

the transpose argument allows us

00:06:21

to reverse the rows and columns

00:06:23

for example if we select

00:06:25

the hole value again we

00:06:27

only select the first

00:06:29

line when we are going to launch our

00:06:31

procedure we will see that the 5th 1

00:06:33

and the set which here is at the

00:06:35

line level to end up in the collage

00:06:37

at the column level so obviously

00:06:39

here given that the operation argument

00:06:41

has the value xl past special operation

00:06:43

multiply here excess will not

00:06:45

just copy but will also

00:06:46

perform a multiplication for

00:06:48

only used the argument that

00:06:50

interests us which is the transpose argument

00:06:52

we will give the value of that

00:06:54

not this special operations gives to this

00:06:56

argument this way if we re

00:06:58

select our cells that we

00:07:00

launch the procedure we will

00:07:01

actually find June 5 and 7

00:07:03

which will be here in column so as

00:07:04

usual you can download the

00:07:05

rescue support by following the link

00:07:07

that you will find in the description

00:07:08

of the video

00:07:09

you liked it don't forget

00:07:10

to lalique and share it with your

00:07:12

colleagues and friends on all of your

00:07:13

social networks and you can also

00:07:14

leave your impressions in the

00:07:16

comments area I will read each one of

00:07:18

them and would respond with pleasure

00:07:19

obviously if it is not yet done

00:07:21

subscribe to the channel so as not to miss

00:07:22

any tips it is also very

00:07:24

important to help me gain

00:07:25

visibility in order to be able to develop the

00:07:27

channel and continue to offer

00:07:29

lots of new videos

00:07:30

thank you for following this video and see you

00:07:31

soon for a next tutorial

Description:

❤️ S'abonner à la chaîne : https://www.youtube.com/channel/UCXyZxDPY_d-ehSYV0CH3W9A/?sub_confirmation=1 💻 LIEN DE L’ARTICLE ET DE TELECHARGEMENT : https://www.excelformation.fr/range-formation-vba-excel-complete.html 🗨️ Dans cette nouvelle partie de ce chapitre de découverte de la gestion des cellules en VBA, nous allons découvrir comment réaliser automatiquement des copiers-collers en utilisant des macros commandes VBA. Il s’agit en effet d’une des possibilités offertes par VBA qui permet de réaliser des actions extrêmement puissantes de manière totalement automatisée et qui amène par conséquent des gains de temps très importants dans le cadre de réalisations des tâches quotidiennes. 📢 Posez-moi également toutes vos questions dans l’espace des commentaires, je me ferai un plaisir d’y répondre ! ============================================= 📚 Formations Excel offertes : - Formation Excel pour les débutants GRATUITE : https://www.excelformation.fr/formation-excel-debutants.html - Formation VBA complète GRATUITE : https://www.excelformation.fr/formation-vba-complete.html ============================================= 📑 SOMMAIRE : 1. Copier ou couper les cellules 2. Coller des cellules 3. Collages partiels (uniquement la valeur, le format,…) 4. Libérer la mémoire ! ============================================= LIENS UTILES : - Tout savoir sur les boucles For … Next et For ... Each en VBA [#15 FORMATION EXCEL VBA COMPLETE] = https://www.excelformation.fr/boucles-vba-excel-complete.html - Manipuler les cellules en VBA avec l’objet Range [#21 FORMATION EXCEL VBA COMPLETE] = https://www.excelformation.fr/range-formation-vba-excel-complete.html - La notion d’objet dans le langage VBA [#10 FORMATION EXCEL VBA COMPLETE] = https://www.excelformation.fr/les-objets-formation-vba-excel-complete.html - Select Case : Réaliser plusieurs Test conditionnels en VBA [#14 FORMATION EXCEL VBA COMPLETE] = https://www.excelformation.fr/tests-logiques-select-case-vba-excel-complete.html - IF...THEN ou Comment effectuer des tests logiques simples en VBA [#11 FORMATION EXCEL VBA COMPLETE] = https://www.excelformation.fr/tests-logiques-if-then-vba-excel-complete.html - Présentation de Visual Basic Editor (VBE) = https://www.excelformation.fr/presentation-vbe-formation-vba-excel-complete.html - Analyse d’une macro VBA = https://www.excelformation.fr/analyse-macro-vba-formation-vba-excel-complete.html - Comment lancer une macro VBA (13 méthodes !) = https://www.excelformation.fr/lancer-macro-vba-formation-vba-excel-complete.html - Focus sur les variables en VBA [#05 FORMATION EXCEL VBA COMPLETE] = https://www.excelformation.fr/variables-vba-formation-vba-excel-complete.html - Formation VBA d'Excel complète = https://www.excelformation.fr/formation-vba-complete.html ============================================= 👨‍👨‍👧‍👦 Réseaux sociaux : - Facebook : https://www.facebook.com/unsupportedbrowser - Twitter : https://twitter.com/excelformation

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Copier et coller des cellules en VBA avec le presse-papier [#24 FORMATION EXCEL VBA COMPLETE]"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.