I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.

Information on
St. Joseph's

 

- Read from spreadsheet cells:
Give a cell a name, for example:

Now you can read or refer to this name from within VBA with
Dim s as string
s = Range("City").Text
Please notice that you can define names which are valid for worksheets only and names which are valid for the whole workbook.

- Read from files:
http://erlandsendata.no

- Avoid reading manual input

[Previous]  [Next]