array

  1. D

    Array, array go away.... I'm Stuck. Please Help!

    Sheet Name: 'TOOLS!' <tbody> A B C 1 Opening Max Bend Tool 2 0.520 150 ABC 3 1.125 105 DEF 4 2.000 95 GHI 5 3.000 100 JKL </tbody> Sheet Name: 'CHART!' <tbody> A B C 1 Material Pref Opening Use Tool 2 10GA 1.125 ??? 3 8GA 2.000 </tbody> There are several...
  2. C

    Filter issues

    Hi, My filter does not work properly. It just displays a minor portion of all values in the column. I have no blank rows in the table array. How do I solve this?
  3. P

    Excel VBA Compare two array and create result array

    Hi everyone I have two array (each array have three column , have about 18.000 row). I want to compare array1, array2 , then creat a result array. For more detail, Pleae go to my link for xlsb http://www.mediafire.com/file/r38m45t2s93wy5y/compare_array-.xlsb/file Image of my array. And here is...
  4. N

    VBA - Find and Add cells to dynamic array

    I have column C with the following structure: [blank] item1.1 item1.2 item1.3 BA1 [blank] item2.1 item2.2 BA2 [blank] item3.1 item3.2 item3.3 BA3 [blank] and so on... I am looking for a macro that finds let's say "BA2" and then adds all items above "BA2" (until a blank cell is reached) to a...
  5. M

    Multiple table array

    Hello All, I am trying to use an excel formula that calculates for me the match of two columns and show me the results. If I want to calculate one column I am using this formula: =IF(ISERROR(VLOOKUP(E18,A18:A22,1,0))=TRUE,"",E18). It's working really good, but it's seems impossible if i want...
  6. L

    extending array per every input

    Hey guys, im trying to fill up my array and extended whenever needed: arraySizeX = 1 arraySizeY = 2 ReDim Preserve orderArray(1 To arraySizeX, 1 To arraySizeY) orderArray(1, 1) = "test" orderArray(1, 2) = lastRow - 1 arraySizeX = arraySizeX + 1 ReDim Preserve orderArray(1 To arraySizeX, 1 To...
  7. rhino4eva

    Using an array to chage a reference but do the same job

    Sub RESET() Dim WS As Worksheet Set WS = ThisWorkbook.Sheets("Sheet1") WS.Range("B2").ClearContents WS.Range("B3").ClearContents WS.Range("A4").ClearContents WS.Range("B4").ClearContents WS.Range("C4").ClearContents WS.Range("F1").ClearContents...
  8. L

    union range into array

    Hey guys, I'm trying to dodge making cycles to fill up my array, so i was hoping to just do this: lastRow = Cells.Find(what:="*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row Set bigRange = Application.Union(Range(Cells(2, 3), Cells(lastRow, 3)), Range(Cells(2, 4), Cells(lastRow...
  9. L

    Storing variables into array after removing duplicates

    Hello guys, i'm storing a range of variables into a 1d array and i want to remove the duplicate variables beforehand instead of clearing the array after. My function is: Function StoringIntoArray(startSKU As Long, endSKU As Long, columnSKU As Long) Dim arTmp Dim skuArray() Dim...
  10. A

    How to use find difference in a single column and then add if positive? Also using array function and normal function in a single function.

    Dear Experts, Please help Please guide me with the questions highlighted in yellow.
  11. E

    modification needed - stumped!

    The code takes entry information ("entries") and prefills another worksheet ("Final_Wash") with that data. Works flawless. I would like to modify the code so that it looks at the "entries" worksheet, column I and only selects those records with a "W". Usually pretty good at modifying existing...
  12. S

    Storing an array of dates into single cell

    Hello, I am trying to store multiple dates in a single cell as an array, similar to ={1,2,3} and due to the structure of my table I can't use more than one cell for the content of the array. The dates are formatted like this: 14-9-2018 14:00 (d-m-yyyy hh:mm) I can't store the dates as text...
  13. C

    Using the text from another cell to in a part of a array

    I have a table with some values that i want to sum according the year, name a store, and them according the current month... (I want to sum the accumulated values since the beginning of the month) I have a VLookup that gets me the text i want in the array: <colgroup><col width="221"...
  14. T

    VBA, Add hyperlink to each line of selected lines of text in word.

    First time learning VBA. I want to write a VBA script to add a hyperlink to each line of a range of selected paragraphs in word 2016. The hyperlink would open a document with the filename matching the line of text selected and are stored in the same folder. Here what I found and put together...
  15. D

    Calculate GPA from Grade List

    I am doing admin for a college department. I want to enter the student's grades in A1:A10, for example, and in one cell, to convert those grades to grade points...an A becomes 4.0; a B+ becomes 3.3, etc. I tried doing a vlookup for multiple lookup values. If I do...
  16. M

    Using an array value to sort a row to a specific Worksheet

    I've recently tried to make a switch towards using for loops as opposed to just writing out all the code but I have run into an issue when using an array to sort rows based on an array value. I have a table containing all the worksheet names and variables I wish to sort by. The data that needs...
  17. C

    VBA to pull reference a different worksheet

    Hello, I have a workbook that has a VBA code. I use this workbook for company ABC and my coworkers use it for many other companies. There are like 5 iterations of this workbook. Each workbook has about 10 worksheets, including a "Raw Data" tab. The VBA code in each workbook essentially...
  18. P

    How do you calculate the size of an array?

    Here's an array I'm using: Dim Array (1 to 4, 1 to 400000, 1 to 12) as long How big is this array? How big would it be as a double or string array?
  19. J

    Array forumla not working with .FillUp

    My "Clean Up" has this: <code> Case "Working_Dispatch" lr58 = wsClear.Cells(Rows.Count, "D").End(xlUp).Row Set clRange = wsClear.Range("A2:U" & lr58 + 2) clRange.FillUp 'autofill upwards to cleanse, keep formatting </code> A formula example I am using [array] is here...
  20. B

    Return all rows that match condition

    <tbody> A B C D E F G H I Line Quantity Description Price Extension Tax Rate Tax AMT Type Total 1 25 descript 1 5.00 125.00 .0825 10.31 Composite 135.31 2 150 descript 2 10.00 1500.00 .0825 123.75 Non-Composite 1623.75 </tbody> Hello, I have a table...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top