Auto fit Method

     

  • If data\content of the cell is more than its width, we can adjust the data in a cell by increasing the column width

    •  

  • Autofit method enables the user to fit the data in a particular cell by increasing column width

    •  

  • Syntax:

    Range.Columns.autofit

  • Syntax:

    Range.Rows.autofit

    •  

    Range represents to entire row or entire columns., it doesn't allow the user to fit individual cell range like range('A1"),range("B1")..., it shows error message

     

     

     

     

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