+ Reply to Thread
Results 1 to 4 of 4

1D Array Naming Conventions

  1. #1
    Forum Contributor
    Join Date
    01-25-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2016
    Posts
    166

    1D Array Naming Conventions

    I have some code that counts the dimensions in an array. But I am experiencing two types of 1 dimensional arrays (for ease of explanation I show them via dim statements but there could be other ways, such as redim or copying a single row into an array, to obtain these:

    Please Login or Register  to view this content.
    Of course when using these two arrays there would be different ways to refer to them in my code, i.e.
    Please Login or Register  to view this content.
    I have written code to differentiate between the two and am now writing my comments section.

    My question is what is the proper naming convention for these two one dimensional arrays? Right now I am calling the first a "true" 1d array - but suspect that's not right?

    Thanks in advance,
    Last edited by tom.hogan; 05-11-2014 at 10:53 AM.
    Tom

    If my answer resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post
    .

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: 1D Array Naming Conventions

    Tom

    The second array isnt't really 1-dimensional.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    01-25-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2016
    Posts
    166

    Re: 1D Array Naming Conventions

    That may be technically true, but when you count the array dimensions the answer will be 1.

    Regards,

  4. #4
    Forum Contributor
    Join Date
    01-25-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2016
    Posts
    166

    Re: 1D Array Naming Conventions

    Norie,

    You're right, I rechecked and counted the array dimensions and got 1 for the first and 2 for the second - to all sorry for posting something I should have figured out on my own.

    Regards,
    Last edited by tom.hogan; 05-11-2014 at 11:13 AM.

+ 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. [SOLVED] VBA naming conventions
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 09:36 AM
  2. Naming conventions and code maintenance
    By Kyle123 in forum The Water Cooler
    Replies: 1
    Last Post: 03-07-2012, 06:14 PM
  3. Importing Naming Conventions
    By john432 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2008, 02:47 AM
  4. File naming conventions
    By gidget in forum Excel General
    Replies: 7
    Last Post: 11-15-2005, 10:20 AM
  5. Naming conventions of objects in VBA
    By whiteliyl_111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2005, 10:59 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