Thisworkbook property

[rhombus4]

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"
Sheets("Sheet1").Range("myrange").Offset(1, 2) = "Yes"
ThisWorkbook.Sheets("Sheet1").Range("myrange").Offset(1, 3) = "Yes"

ThisWorkbook.Range("A5").Offset(0, 1) = "Yes" 'Compile Error : Method or data member not found
ThisWorkbook.Range("myrange").Offset(4, 1) = "Yes" 'Compile Error : Method or data member not found
ThisWorkbook Range("myrange").Offset(4, 1) = "Yes" 'Compile Error : Invalid use of property
ThisWorkbook.[myrange].Offset(4, 1) = "Yes" 'Compile Error : Method or data member not found

ThisWorkbook.Sheets("Sheet1").[myrange].Offset(4, 1) = "Yes"

 

[steve the fish]

If i told you to go to cell A1 of a workbook with 10 sheets which one would you go to? You would have a choice of ten cell A1s. All worksheets in a workbook have a cell A1. For that reason the parent of the cell is the worksheet not the workbook.

 

[rhombus4]

Thanks

Knew you had to use sheet when using A1 for example but didn't realise you had to do it for named ranges as well seeing as [my range] isn't on every sheet it's only on one sheet, in my case sheet1.