Скачать или смотреть Complete Guide to Modifying Cells and Ranges - Excel VBA

Ranges are incredibly useful in Excel VBA because most data and useful functionality of Excel occurs in the cells. With a strong understanding of the Range Object in Excel VBA we can begin to design Macros that will greatly enhance our workbooks and automate tasks.

For shorter sections extracted from this video and more resources on the Range(Object) please see the Range(Object) - Excel VBA playlist here:
   • Range(Object) - Excel VBA  

00:00 Introduction
00:57 Get Value
01:24 Set Value
01:49 Get Formula
02:10 Set Formula
03:15 Add Comment
03:56 Clear Comments
05:24 Append to Comment
06:23 Read Comment
07:05 Clear Cell/Range
07:28 Clear Content
08:13 Clear Format
08:46 Add Hyperlink
11:30 Remove Hyperlink
12:23 Copy and Paste Cell/Range
15:14 Delete
16:07 Insert
16:42 Fill
19:28 Group/Ungroup
20:14 Merge/Unmerge
21:03 Replace
21:39 Expected = Error

More Excel VBA tutorials here:
   • Getting Started with Excel VBA  

Engineering Statistics Videos here:
   • Engineering Statistics  

For support or inquiries please contact our support line: [email protected]

Excel Range(Object) Documentation: https://learn.microsoft.com/en-us/off...)