Add Sheet With Name Excel VBA Macro

Поделиться
HTML-код
  • Опубликовано: 4 дек 2024
  • Get Excel VBA Objects Guide to learn more about the Worksheet and other VBA objects: excelmacroclas...
    In this video we see how to add a worksheet with name in Excel using VBA macros. We also see the difference between sheets and worksheets, and explore the various parameters that can be used when adding a new sheet in Excel. We can add a worksheet before or after a particular existing sheet, and we can also specify the number of sheets we want to add. We can use the Count property to add a sheet after the last worksheet in the workbook.
    Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclas...
    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 (excelmacrofun....)
    Excel Macro Business (excelmacrobusi...)
    Excel Macro Sports (excelmacrospor...)

Комментарии • 4

  • @logginlocos9023
    @logginlocos9023 6 месяцев назад +1

    Excellent technique!

  • @nadermounir8228
    @nadermounir8228 Год назад +2

    Thank you for this nice video 📹

  • @girishv6981
    @girishv6981 Год назад

    Hi how to split Excel wise ?

    • @ExcelMacroMania
      @ExcelMacroMania  Год назад +1

      Do you mean to split the worksheet in two or more views? For that you need to target the Window object as follows:
      Windows(1).NewWindow
      Windows.Arrange xlArrangeStyleVertical