Question: ```
Dim myText As String
myText= Range("a3").Text

```

Returns the formatted value in cell A3, but 

```
myText= Range("a3:c7").Text

```

gives me an error. 

How do I get strings representing formatted values from a multi-cell range, while preserving the number format? i.e. the format of the output text would be the same as if copy-pasting from the range to a text editor.

Answer: 
```
For Each c In Range("a3:c7")
    ItemName = c.Text
Next c

```

This will give you each cell one after the other.
Make a collection and run through all the Areas of the range and collect the text into 
the collection.