+ Reply to Thread
Results 1 to 3 of 3

Help reading 'redim' code

  1. #1
    Registered User
    Join Date
    06-25-2017
    Location
    London, England
    MS-Off Ver
    Windows 10
    Posts
    1

    Help reading 'redim' code

    Hi Guys,


    I am both new to this forum and also new to coding. I am trying to figure out what this code means as I am new i cannot find a proper description of what this means. I get stuck on the 'redim' part. Does this mean that the answer of my future coding will go into row a and coulmn d+1?????

    Please Login or Register  to view this content.
    Also as a side note, is there any helper for the coding as normal excel usually tells you how to fill out your functions with a wizard like feature. Please let me know.
    Last edited by oslo123; 06-25-2017 at 11:40 AM. Reason: Code tags added. Please read forum rules.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Help reading 'redim' code

    Hi Oslo123,
    welcome to this forum.
    The Redim-statement is used to define dynamic arrays and is used in conjunction with Dim-statement.
    Dynamic arrays are used when their size is not fixed.
    Normal syntax would be
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Help reading 'redim' code

    Please Login or Register  to view this content.
    0 to n; n+1 elements.
    Entia non sunt multiplicanda sine necessitate

+ 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. Easy Question
    By chantage in forum Excel General
    Replies: 6
    Last Post: 11-30-2006, 08:22 AM
  2. Easy if then question?
    By adamcornwell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2006, 11:31 PM
  3. easy question?
    By kyegibbon in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-13-2006, 04:25 AM
  4. [SOLVED] Probably an easy question.
    By Lost Secretary in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-22-2006, 02:00 AM
  5. [SOLVED] *EASY* question!
    By Laura \( '_' \) in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-25-2005, 08:10 AM
  6. [SOLVED] Easy VB code question
    By Anthony in forum Excel General
    Replies: 2
    Last Post: 07-08-2005, 04:05 PM
  7. new user with easy question? not easy for me
    By speakeztruth in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2005, 05:05 PM
  8. easy question
    By Dahlman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2005, 07:06 PM

Tags for this Thread

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