I have the following loop that gives me an error:
However, if I turn the loop off and just set j=3, it outputs the data into the cells of the sheet that I currently have selected fine. What am I missing?For j = 3 To 5 'j = 3 _Data = Array("A", "B", "C", "D", "E") Sheets(j).Range(Cells(1, 10), Cells(1, 14)).Value = _Data Next j
Thanks
Bookmarks