Recent content by slawson7

Muchos kudos to PHV, and thanks to duGly for backing it up. Worked brilliantly.

I have the following code: Sub datefunctions() rightMostColumn = Range("A4").End(xlToRight).Column Set myRange = Worksheets("temp").Range(Cells(4, 1), Cells(4, rightMostColumn)) mindate = Format(Application.WorksheetFunction.Min(myRange), "yyyymmdd") For i = 1 To...

Thanks to Skip, Glenn and sfatz.

Thanks Glenn & Skip (again!). Being an ex-DBA, I think of two-dimensional arrays as tables, with rows and columns. I start out with a 'table' that has three 'rows' and one 'column'. So to add another column, I would have to do: redim myArray (2,1) redim myArray (2,2) redim myArray (2,3) ...right?

Following on from my previous question on arrays (thanks for the help on that, BTW). I have the following code: Dim myArry (1,3) myArray (1,1) = "x" myArray(1,2) = 1 myArray (1,3) = 1 . . . ReDim Preserve myArray (2,3) The ReDim statement throws a compilation error, "Array already...

Bob - Thanks for the help. It is an array I'm talking about - I could use a spreadsheet to hold the value, but I think it would be clunky. Skip - Thanks for the pointers, but I'm not sure I see how this helps. I need to search for the value in my header row in the array before I decide whether...

I want to create an array which looks like the following: ---------------------------- HEADER1 | HEADER2 | HEADER3| ---------------------------- 15 |20 |25 | 1 |2 |3 | This is a dynamic array. It will have at least one column, but most likley more. If my...