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

Excel Formation March 13, 2020
Video Thumbnail
Excel Formation Logo

Excel Formation

View Channel

About

Excelformation.fr propose de nombreuses formations pratiques et gratuites sur Microsoft Excel : des cours pour apprendre à structurer et analyser les données, des tutos sur les fonctions avancées, les formules et les formules avancées d'Excel, les formules matricielles, les mise-en-formes conditionnelles, les graphiques Excel (xls, xlsx, xlsm,…). Des tutoriels pour apprendre à automatiser les tâches répétitives (via des macro-commandes en VBA) de vos classeurs Excel.

Video Description

❤️ S'abonner à la chaîne : https://bit.ly/31xepIW 💻 LIEN DE L’ARTICLE ET DE TELECHARGEMENT : https://www.excelformation.fr/range-formation-vba-excel-complete.html 🗨️ Dans ce nouveau chapitre de la formation sur l’apprentissage de VBA, nous allons découvrir comment manipuler l’un des objets les plus essentiels des macros en VBA, il s’agit de l’objet Range qui permet de manipuler des cellules ou des plages de plusieurs cellules. 📢 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. Manipuler la plage des cellules sélectionnées : Selection 2. Obtenir la cellule active : Activecell 3. Cellule liée à un évènement : Target ============================================= 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/excelformation.fr/ - Twitter : https://twitter.com/excelformation

You May Also Like

Essential Gear for Your Camera

AI-recommended products based on this video

Loading...
NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

(2,807)
$181.49
FREE delivery Sun, Aug 10
Loading...
KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease, and More

KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease, and More

(51)
$49.99
FREE delivery Mon, Jun 16
400+ bought in past month
Loading...
Portable Steam Cleaner, Hand Held steamers for cleaning house, Home Multi Purpose-10-Piece Accessory Kit for Sofa,Carpets,Upholstery,Car,Floor,Bathroom,Mattress and More

Portable Steam Cleaner, Hand Held steamers for cleaning house, Home Multi Purpose-10-Piece Accessory Kit for Sofa,Carpets,Upholstery,Car,Floor,Bathroom,Mattress and More

(145)
$52.99
FREE delivery Wed, Jan 7
Loading...
Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White
Best Seller

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

(9,766)
$9.89
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
Water Heater Cleaning and Flushing Tool, Sediment Buster Hot Water Tank Flush Kit, Breaks Up Stubborn Clogs, Remove Sediment & Dirt Easily, Friendly Plumbing Maintenance Kit for Electric & Gas Heaters

Water Heater Cleaning and Flushing Tool, Sediment Buster Hot Water Tank Flush Kit, Breaks Up Stubborn Clogs, Remove Sediment & Dirt Easily, Friendly Plumbing Maintenance Kit for Electric & Gas Heaters

(0)
$15.39
$4.99 delivery Jun 19 - Jul 3
Loading...
SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

(71,074)
$21.99$16.59
FREE delivery Sun, Aug 10 on your first order
500+ bought in past month
Loading...
SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN
Best Seller

SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN

(71,074)
$29.99$26.61
FREE delivery Sun, Aug 10 on your first order
4K+ bought in past month
Loading...
Lexar 128GB Micro SD Card, microSDXC UHS-I Flash Memory Card with Adapter - Up to 100MB/s, A1, U3, Class10, V30, High Speed TF Card

Lexar 128GB Micro SD Card, microSDXC UHS-I Flash Memory Card with Adapter - Up to 100MB/s, A1, U3, Class10, V30, High Speed TF Card

(26,884)
$18.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
Lexar D40E 128GB Dual Drive USB 3.2 Gen 1 Type-C™ Jump Drive, USB-C Flash Drive Metal Housing Swivel Design Thumb Drive

Lexar D40E 128GB Dual Drive USB 3.2 Gen 1 Type-C™ Jump Drive, USB-C Flash Drive Metal Housing Swivel Design Thumb Drive

(2,310)
$22.99
FREE delivery Sun, Aug 10 on your first order
2K+ bought in past month
Loading...
Lexar D40E 256GB Dual Drive USB 3.2 Gen 1 Type-C™ Jump Drive, USB-C Flash Drive Metal Housing Swivel Design Thumb Drive

Lexar D40E 256GB Dual Drive USB 3.2 Gen 1 Type-C™ Jump Drive, USB-C Flash Drive Metal Housing Swivel Design Thumb Drive

(2,310)
$35.99
FREE delivery Sun, Aug 10
2K+ bought in past month