Intermediate level VBA questions that should be super simple to answer if you already know

[zzzjoshzzz]

There are three basic questions, and I've an attached an excel sheet that gives a clear example of what I mean:


1)How do I organize tables (to treat them like an array) and access elements in Excel VBA?
-Is there a way to name the table as either an array or a range?
-How can I regularly and simply access data elements?




2)Are there functions in Excel VBA to find a cell containing "sample text" within a given range?


3)What is the Excel VBA command to place a value in a cell for which I have the address?
Example file that makes all my questions clear with examples of what I need:

https://onedrive.live.com/redir?res...113&authkey=!AEZfNwpY5PgGdBc&ithint=file,xlsx