How to store the value of a cell in a string

Question

I want to store the value of cell [136,7] in sheet Schools in a string

Dim Num As String

Num = Schools.Cells(136,7).Value

This code won't run. I am suspecting the error occurs because I cannot refer to my sheet directly use its name. But I do not know how to remedy this.

Pᴇʜ · Accepted Answer · 2019-05-22T14:14:24.590

1

Note that there are 2 different naming systems:

The VBA code name of a worksheet (which can be changed in the Project Explorer in VBE)
```
Num = Schools.Cells(136,7).Value
```
The tab name of the worksheet (which can be changed by any user)
```
Num = Worksheets("Schools").Cells(136,7).Value
```

Note that Schools and Worksheets("Schools") can be 2 completely different worksheets. These 2 naming systems are completely independend.

edited May 22 '19 at 14:14

answered May 22 '19 at 14:13

Pᴇʜ

It returns Application-defined or object-defined error when I use both – koch May 22 '19 at 14:20
@koch You should only use one of them. Try `ThisWorkbook.Worksheets("Schools")` then. Is the worksheet `Schools` in the same workbook as the code? – Pᴇʜ May 22 '19 at 14:23

1 Answers1