redim array

Hi all, I've pieced together the below code from other forums to achieve something I thought would be relatively simple, but it has thrown up an error which I'm not capable of solving. I have two ranges B44:E58 and H44:K58- products are listed starting at B44 with various details in the...

Hi folks, I have a variant array that I would would like to break up into individual arrays and I'm realizing I haven't figured out how to do that yet. Mini-sheet example below. Goal: In vba (not in sheet) array would like to either A) Make smaller arrays for each department based on the...

Hi there, I managed to run the script only once without error. But now I get a value error and it seems that the Redim is not resizing the arrays. Originally I used Redim Preserve but after the error I also tried to resize them at the initialization, but neither of them seems to work now. Here...

I am writing a VBA code which loops through a defined range in a worksheet, finds the filled cells within its limits and assigns the x,y values of each cell into an array. This is my code: Sub FindCells() Dim lWidth as Integer, lHeight as Integer 'both of these parameters are subject to...

Relatively newbie to VBA and I've been having problems with this code. It worked at one time, but for the life of me I can't figure out why it can't find the first item in the array. What I'm trying to do is search a directory for Excel files that match a specific word (this works) and store...

I have two public arrays that I am using on one worksheet. When I run the code for one of the tests it shows 13 variables were read in. When run the test again and only one variable should have been added I still see 13 variables. This is why I am trying to clear the array each time I start. All...

Have a spreadsheet with two columns. Parse data, both the # & letters; then output onto bucketed i.e. 1-100 tab w/corresponding letter/ <tbody> 7.259764189 a 271.7909785 b 69.12924367 c ... ... </tbody> Writing VBA code (even though this could be done manually) so that the numbers are...

hello, I have a column with data that I work with (let's call it A). Based on A I get data from AS400 PCCOM IBM emulator (let's call it B). What I need to check on is whether B data is unique or not. If B is a duplicate, then I need to check whether C column (value known from the beginning)...

Hi, I tried do: Dim MtxVal() As String ReDim MtxVal(1 To final + 1, 1 To LastColNumb + 1) but its not running. What could I do when I don't know values of parameters "final" and "lastcolnumb"?

Hi everyone, I have a difficulty in working with excel arrays. I wish to create a sheet from 2 seperate ranges. Below are the details. i am trying to create a report every week. Range 1 is in Sheet1: Columns("A:C"). the data in these columns may increase or decrease every week. Range 2...