Two part tuesday morning problem...
<font color=blue>sTest = ThisWorkbook.Worksheets("Line 2").Range("S14").Value</font color=blue>
is my code, i've been playing with it for ages, and can't find how to introduce a variable in to the equation, eg:
<font color=blue>MyLoop = 14
sTest = ThisWorkbook.Worksheets("Line 2").Range("S & MyLoop & ").Value</font color=blue>
I've tried all manner of speech mark combinations but still can't get it.
Secondly, is there a way to make this line of code, copy the value, and not the formula in the cell.
<font color=blue>Sheets("Line 2").Range("A14:Q14").Select