jagged array

Sub Reconcile() Dim InputworkBook As Workbook Dim ReportsToReconcile As Variant ReportsToReconcile = Array("Report1", "Report2") Dim ReconcilingReport As Variant Dim ReportIndex As Integer ReportIndex = 0 Set InputworkBook = Application.Workbooks.Open(Application.GetOpenFilename, ReadOnly:=True)...

Hi all. I have a spreadsheet with x number of columns, I'm looking for the string "YES" in each row of a specified column and once found I place the name linked to the fruit into a jagged array. For example I have a name, surname and fruit columns. The reason I would like a jagged array is that...

I am trying to run some macros based on whether or not a radio button is selected. I am using a For Loop to do this, but cannot figure out how to reference the button based on where its name is indexed in an array of arrays which contain references to reports, buttons, and sheet names. Here is...

I have a jagged array containing normal values and formulas in R1C1 notation and I want to write it into excel. I used following code for the same dataRange.Value2 = jaggedArray; But it produced unexpected results in case of column anchored formulas like '=$A1'. I got it fixed by rewriting...

Hello everyone Below you see a part of a subroutine where I want to assign an array, which I create with a function (displayed further down) to an element of an array. To my understanding this should result in a jagged array. Unfortunately i get a run-time error 13: type mismatch on the line of...

I have a powershell script that I run to produce a folder listing & size file text file. I give it a root folder to start in & it goes thru each folder recursively summing up the file sizes within the folder. The end result is like this: Myfolder|5800 Bin|1800 |de|40000 |en|50000...

Not entirely sure how to title what I need doing, so I hope the one I chose is alright. I'm fairly new to VBA, so I don't know much, and this is my first post here. OK, this is a bit complicated, so let me set up an example of what I'm dealing with before I go on to explain what I need in the...