LinkBack URL
About LinkBacks
hi
NOTE: My vba knowledge is basic I am getting there slowly.
I feel stupid asking but this code will not work and I get compile error constant expression required array.
Thanks.
Dim i As Integer For i = 1 To LastCol Dim orderMonth(i) As String Next
hi
NOTE: My vba knowledge is basic I am getting there slowly.
I feel stupid asking but this code will not work and I get compile error constant expression required array.
Thanks.Dim i As Integer For i = 1 To LastCol Dim orderMonth(i) As String Next
Just to give you some direction
Sub test() Dim i As Integer, LastCol As Long LastCol = 2 Dim orderMonth(2) As String For i = 1 To LastCol orderMonth(i) = i Next End Sub
I'm not sure what you're shooting for. This declares a string array that has 10 elements.
Dim LastCol As Long Dim orderMonth() As String LastCol = 10 '??? ReDim orderMonth(1 To LastCol) 'The string array orderMonth is set with 10 elements
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks got it working.
Dim i As Integer, LastCol As Long Dim orderMonth(50) As String For i = 1 To LastCol orderMonth(i) = i Next
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks