Explain about OFFSET Method

     

  • Offset method considers one range object as base and created another range object

    •  

  • Offset method having two functional arguments

    •  

     

    It indicates:

     

  • How many rows top\bottom to base row
  • How many columns up\down to base column

    • Example:

     

     

  • range D4 is the base range

    •  

    Example:

     

     

    Selection of ranage through offset:

     

     

     

     

     

     

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