in
All Tags » VBA » Array (RSS)

Browse by Tags

  • Redim array

    Hi I hope you can help. I'm also hoping that this will be quite simple....:-) I have a macro which stores data into an array. The array is (?,8). For various reasons, I don't want to count the potential number of entries before dimensioning the array, so I need to store the data into it and then...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Modify Values in Array and pass back to format Excel Spreadsheet

    I am passing a recordset to an array and that part is working fine. Code I am using to do that is below. Based on the values in the array I want to change the value to correspond with the appropriate color from the color index. I am using a function to but when I run the code I get a type mismatch error...
    Posted to Visual Interdev (Forum) by microsoft on 05-15-2010

  • Load object (array like) into table in one go.

    I have an object (cellset) that contains multiple dimensions much like an array. Currently, I'm looping through the cellset adding each record to a table 1 row at a time. Is there a way to load the contents of the object in one go. I remeber using this trick in Excel once to load an array to a worksheet...
    Posted to Access Coding/Macros (Forum) by microsoft on 03-03-2010

  • Hierarchical Tree from an Array in VBA

    I have a 2D array that has Parent Child relationship. The data is such that one parent can have multiple children, and same child can have multiple parent. The data should be displayed in a column in the Excel displaying the hierarchy. The attached Excel shows the possible data in two columns and the...
    Posted to Excel (Forum) by microsoft on 03-02-2010

  • removing invalid characters in vba

    I have some code wich is returning an error, newsheetname is a variable which sometimes has characters such as / or \. I cant then use that variable to name a sheet and so I was simply going to replace all invalid characters with an - But where am I going wrong and getting variable uses an automation...
    Posted to Excel (Forum) by microsoft on 01-12-2010

  • How to initialise array values to 0 in access VBA

    I have a module with multiple procedures. The arrays are defined right at the top. So when I execute a procedure multiple times the values in array are notinitialsed but are carried over from previous action. is there any single statement by which all values of all elements in array I can make zero ...
    Posted to Access (Forum) by microsoft on 09-20-2009

  • How to lookup a match in an array within Excel VBA ?

    Hi, Would like to ask : other than looping and compare each value in the array, are there any VBA functions which can lookup an array for a specific match ? Cheers Stanley
    Posted to Excel (Forum) by microsoft on 09-18-2009

  • VBA, arrays and Consolidate

    Hi guys... maybe this is an easy one. I have this Macro in Excel VBA and it works: ----------------------------------------------------------- Selection.Consolidate Sources:= _ Array("'Consolidado'!R10C1:R16C3", _ "'Consolidado'!R18C1:R27C4") _ , Function:=xlSum, TopRow...
    Posted to Microsoft Office (Forum) by microsoft on 09-09-2009

  • Copy MS Access Table into a VBA Array

    I am trying to read an entire MS Access table in to a VBA array. What is the best way to do this?
    Posted to Access (Forum) by microsoft on 09-08-2009

  • VBA Sorting a Multi-Dimentional Array

    Hi All, If I have an array of random un-sorted values, is there a way that I can quickly sort them (i.e., Array().sort)? Is it possible to use this method on a multi-dimentional array by specifying the dimention that you want to sort on? -Regards,
    Posted to Excel (Forum) by microsoft on 08-17-2009
Page 1 of 3 (30 items) 1 2 3 Next >