Could someone please tell me why I am getting an Error 9 (Subscript out of range) with the following loop?
[VBA]
sub createHeadingNames()
Call getCols
Sheets("History)").Activate
Application.screenUpdating = False
Dim goatHeadings As Variant
Dim i As Integer
goatHeadings = Range(headingstartRng, Range(headingstartRng).End(xlToRight)).Value
For i = 1 To currentCols
Cells(2, i).Name = goatHeadings(i)
Next
Application.screenUpdating = True
End Sub
[/VBA]