jkindhappy
Board Regular
- Joined
- Jul 14, 2008
- Messages
- 112
Hi,
I am a starter in VBA. Below is apart of code in which I am getting error in the bolded and the under lined line. Can I have some suggestions how to rectify this.
Thank you.
I am a starter in VBA. Below is apart of code in which I am getting error in the bolded and the under lined line. Can I have some suggestions how to rectify this.
Code:
With ws
For i = 1 To Sheets.Count - 1
.Cells(i, 1).Value = Sheets(i).Name
Next i
End With
lr = ws.Range("A" & Rows.Count).End(xlUp).Row
For j = 1 To lr
[COLOR=red][B][U]myArray(j) = ws.Cells(j, 1)[/U][/B][/COLOR]
Next j
For n = 1 To lr
myArray(n).Range("A1:D4").Interior.ColorIndex = 6
Next n
Thank you.