I get an error 2015 at "sourceRange.Cells(1, i);" without offset, in the code below
Code
For i = 1 To WorksheetFunction.CountA(Sheets("To Be Logged").Range("1:1")) + 1
Print #current, " <" & sourceRange.Cells(1, i).Offset(1, 0); ">" & sourceRange.Cells(1, i); "</" & sourceRange.Cells(1, i).Offset(1, 0); ">"
Next i
and im unsure why.
when i replace "i" with "1" it works, but not how i want it to, and when I change it to "2" it doesnt.
the method of selecting a cell works for all the other references just not the middle one, plz help.