In the below lines the first 6 and the 11th work, but lines 7, 8, 9 and 10 don't work
Do you have to use Sheets when using ThisWorkbook
[myrange] = "Yes"
[myrange].Offset(0, 1) = "Yes"
Sheets("Sheet1").[myrange].Offset(0, 2) = "Yes"
Range("myrange").Offset(1, 1) = "Yes"...