excel & array

Help, I am getting the error "Cannot assign to Array" calling on function to return array with values. See code below. Sub Get_Values() Dim Arr(1 To 5) As String Dim Txt As String Txt = "Some Text passed to Function" Arr = Split_Words(Txt) '<--- Error "Cannot assign to Array" End Sub...

I use this code to search in the list box and it works well, but when I search in the first column in the list box for a number, for example 1, 2 or 3, it gives me all the numbers that contain these numbers, so how can I make it show me in the list box only the specified number in the search...

Hi I'm wondering how to make this work. BTW I'm using my phone to send this question. I do have 2 criteria and 3 lookup array. Any method to make this work.

Hello all, This is a difficult question for me to phrase, but I can provide background: I have 200 properties. I have a Statement of Cash Flows with each property listed with hundreds of GL Codes and amounts. I want to summarize the data in a new table by taking whatever GL Codes I want from...

Hi I am trying to deal with thousands of rows of data for updating a montly report. https://exceljet.net/formula/index-and-match-with-multiple-criteria I have refer above pages to found a way to make what I need by using formula but the problem now is I am trying to apply this formula into...

Hi, I previously received some support on the following link Formula Support - Top 10 list using Index and Match, where i was directed to changing my formula to a LET function. The formula worked fine, but i noticed that it was pulling back multiple values with the same name, Is there anyway...

I have the master sheet and data sheet (more than 1 but same format) This is the example of the data from the sheet Project Details Project A Laptop Printer Camera Blank Phone Projector Project C Implementation Debug Smart TV what I need...

VBA: Get all CSV file data from a folder in one excel sheet named "atlas". 1. I have thousands of CSV files in a folder (only two-column data). 2. With VBA can I get the data in one excel sheet named "atlas" from the second row. 3. In the result sheet named "atlas" there are file names (In...

so, I have a workbook that has one sheet that has thousands of rows of data that is constantly being updated, I have managed to create a formula/function that works when I enter it ({ctrl} {shft] {enter}) but as I mentioned, the data sheet is constantly being updated... here is what I have thus...

Hello I'm trying to figure out a way to open the workbooks using the array values stored. The only bug I encounter is at "Workbooks.Open(StoreList(0))" where I encounter "run-time error 0 subscript out of range" but the address is correct so I don't know why it can't find it? Sub uniquestores()...

Hi internet peeps. I am stuck i don't know what code to use so i can search the same column twice for 2 different keyword and then copy data from the same row to another spreadsheet in sequence from a start cell. for details here's what i am trying to do 1. Limit the search within a range of...

I am wondering if there is a way to determine which month did an employee get a consistent performance of at least 3. The problem is we have an employees who have no available data for certain months tagged as N/A. I'm not sure if an array can be used to perform what is needed. Your help will...

I was thinking that I can use Unique formula and get unique list from 2 separate columns, but I struggled with this one. Can I get some help here? Thank you

Hi All, I'm hoping someone can help me.... I have a few sheets that all look the same but there's a value in K2 on some of the sheets that I need to reference to sum up the values. For example: on my Summary sheet, C2 = 1) loop through all the sheets and find "Red" in K2 2) If Red is found in...

when I start my form I'm getting the error "Type Mismatch" Code: Private Sub UserForm_Initialize() Dim split_name() As String, name_person As String Dim c As Long, contar_usuarios As Long Workbooks(OtherBookPath).Sheets("Usuários").Activate contar_usuarios = Cells(Rows.Count...

I have found this piece of code from somewhere else, and I modified it a bit to meet my needs, but I'm not entirely sure how it works. The reason I would like to know how it works is because I would like to modify it further, but I am newer to VBA and do not understand how the Resize, Index, and...

I am trying to loop through a number of cells with vba, and return each cell's value. I used the watch windows, and saw that even though the cell().value returned a number different than 0, the a point array of double was assigned a value of 0. This is the code that I got from a site and edited...

I have workbook, containing 4 major worksheets named as BNF WEEK BNF NEXT WEEK BNF MONTH MAIN Now I am working in sheet named as MAIN and I want formula where, if cell R6 = 1 than fetch data from 1st sheet i.e. BNF WEEK if R6 = 2 than fetch data from 2nd sheet i.e. BNF NEXT WEEK, and so on...

I have created an event like when something changes in a cell, then an advanced filter should happen. The values to be filtered will be in C2:E3 with C2,D2,E2 as headers. the values will be filtered in B6:D67 with B6,C6,D6 as headers. Now the issue is: the values which I filter with...

To start off, I posted the XL2BB sheets and VBA code below to help better visualize my problem. Basically, a macro is run each week to refresh the "FilterList" sheet that results in a varying number of rows of data. There could be 0 or more rows each time the macro is run. From here, I wrote...