array a range

I am trying to create an array that references a range to fill the array. The problem I am running into is that the reference range contains a lot of duplicate values and I only need unique values added into the array. Does anyone have a good sample code that can either remove duplicates from...

Hello all, I have the following problem: I got a table with 15 columns that are updated from a SQL source. There are 10 other columns that contain manual values those I want to save to a collection, update the data from the SQL source and then retrieve the values. My code looks like this: Sub...

<tbody> A B C D E F G 1 Balance Fee ID Service Fee Fee ID From Bal To Bal Service Fee 2 $112.34 1 1 $0 $499.99 $10 3 $112.34 2 1 $500 $1,499.99 $20 4 $1234.21 1 2 $0 $499.99 $5 5 $342.12 2 2 $500 $1,299.99 $15 6 $785.87 2 2 $1,300 $1,499.99 $25 </tbody> I need some...

Hi, I'm trying to put values and formats of cells to an array to faster process them. this seems to work dim area as variant area = range("a10:z20").value This doesn't dim areaformat as variant areaformat = range("a10:z20").font.bold Is there a way to quickly get font and .numberformat and...

Hi, I need help with building a vba script that would copy & paste-append all of my data from their defined "Named ranges" from one workbook to a new workbook. The workbook where I'm copying from has multiple worksheets and they each have their own set of data with their own named ranges...

I have a table where the text "pit1" appears in multiple different rows and columns (ex: "pit1" is in c7, j6, and p16). In the 3 columns next to each of these, there are time values. Ex: c7=pit1, d7= 03:15, e7=05:45, f7=8:15. I'm trying to write a formula that will search the entire spread...

hello, What's wrong in my function? I get #Value. Regards, Andre Function total(zeros As Variant) As Double Dim sum As Double Dim i As Integer sum = 0# For i = 1 To UBound(zeros) sum = sum + zeros(i) Next i total = sum End Function

Hi, Does someone now how to script an 4 dimension array in Excel VBA? Is this impossible? I also wonder if there is an match function that can check positions to in arrays? Like, Dim impossibleArray () impossibleArray(Match funktion here) Need to be an VBA script, not an excel formula...

Hi, Per a Mr. Excel book: VBA And Macros: Microsoft Excel 2010, I coded the following - which works - but currently requires manual updating of the specified array range in the code when data is added to the bottom of the 2 column table. My question is whether there is a way via code to...

Greetings Excel Guru's, <tbody> Clients C B R A Car Bus Rail Air John Public X John Public Jane Doe X X Jane Doe Jane Doe Mary Smith X Mary Smith John Doe X X John Doe John Doe </tbody> Clients list is the master list of all names. From that list, I...

Hi, Basically what I am trying to do is filter a block of data and run a piece of code on 7 of the filtered items. Is there a way (using loops or an array??) to do this without having to do the block of code 7 times (the only thing that will change will be the filtered name. Thanks Gav

Hi After a couple of research I found a code that in theory works with an array of values that define the filter criteria to work with, when I tested as I download it it worked, however when I change those to the values I need, the filter result went blank, so this where I need the assistance I...

Hi I'm used the code below in the past to select from a set of an array (same variables) to copy / paste into the last line it works as it suppose to do it. Nevetheless now the one single rule change, I have to choose from a set of variables within the same range, where the variables are...

Hi I started working with VBA a couple months ago, so I'm not an expert still in my learning curve. Now, I'm trying to hide multiple columns from the multiple worksheets (same columns for all of them), based on the case condition where 1 = Jan, meaning that it will hide everything except Jan...

Hi I am using the following array formula but it is resulting in False {=IF(C20:V20=AE16,(C19:V19))} what I am trying to do is, if any of the value in C20:V20 range = AE16, return me the value in the adjacent cell of that matched value. any help plssss....