Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Difference between two dates
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...- slawson7
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
ReDim Problems
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...- slawson7
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA Array Handling
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...- slawson7
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
