+ Reply to Thread
Results 1 to 2 of 2

Need explanation of range.end property

  1. #1
    Registered User
    Join Date
    11-26-2016
    Location
    Idaho
    MS-Off Ver
    16
    Posts
    3

    Need explanation of range.end property

    I was looking over some code, and I ran into the following line:
    [a100].End(3).Offset(1)
    What does this mean, particularly the "3" after the .End?

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Need explanation of range.end property

    Have a look at this link
    https://www.excelforum.com/excel-pro...end-3-1-a.html
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Explanation of Lookup function and vector form with table as a range
    By AlwaysExcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-12-2018, 06:07 PM
  2. [SOLVED] Row count with cell property...Not range property
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2017, 04:21 PM
  3. excel vba range property non contiguous range
    By Ramo13541 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2016, 08:23 PM
  4. Help with VBA code & or Explanation, mostly about Vlookup, Variable row range
    By Peep_Show_Fan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2016, 08:44 AM
  5. Run-time error 9: Subscription out of Range explanation needed
    By frankt68 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2015, 07:40 AM
  6. Replies: 10
    Last Post: 06-13-2013, 04:12 PM
  7. [SOLVED] Hide columns based on cell value - Unable to set hidden range property of Range Class
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-13-2012, 11:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1