Object Hierarchy

     

  • VBA is Object based language
  • Object hierarchy has been mentioned below

    •  

     

     

  • Application Object
  • Workbook Object
  • Worksheet Object
  • Range Object

    •  

    Excel application consists of one or more Workbooks

    Workbook consists of one or more worksheets

    Each worksheet consists of Range of cells

     

    State about Object_hierarchy withrespect to VBA

     

     

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli