Get the Excel VBA Objects Guide for Intermediate with extended and revised content here: https://excelmacroclass.blogspot.com/...
Welcome to the Excel VBA Objects Series. In this video we learn how to format a range, including the font, interior, and borders of the range, how to format color in VBA, how to change the dimension and arrangement of a range, format values, merge, hide, lock, and group cells of a range. In the next video we will see how to manipulate a range and search/find or replace values in a range, and how to sort and filter values in a range too.
The following videos in the series are going to focus on other Excel VBA objects individually. Among these, and of top of what we've seen so far, we will also cover the Shape object, and the Chart object.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: https://excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)