Results 1 to 4 of 4

Thread: Array(s) Resolved

Threaded View

  1. May 4th, 2003, 12:01 PM #1
    IGBP
    IGBP is offline

    Thread Starter
    Lively Member
    Join Date
    May 2003
    Location
    Los Angeles
    Posts
    126

    Array(s) Resolved

    Hi everyone ...
    brand new to this forum and just learning vb/vba.
    In Excel, i am trying to write a function.
    I have several named ranges and have figured out how to loop through the ranges and get a total of all cells in all ranges.
    Now what I am trying to figure out is ...
    I want to create 4 arrays. 1 for each named range in this spreadsheet(all the ranges are different lenghts and will be added to often). I then want to loop through each range and assign each cells value to one element of the array, reDim and Preserve the array, then get the next value. Once I have all the elements, I can (hopefully) perform some calculations based on certain criteria.
    I am calling the function from a command button click event.
    Any help, ideas, or direction to examples is appreciated.
    Thanks
    Last edited by IGBP; May 16th, 2003 at 09:10 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width