The small company I work for does geo-spatial mapping, and much of our
spatial data is very heavy in tabular attribute data. I have been elected
(forced is more like it!) to start some novice level explorations into
developing simple user forms for our Project Coordinators, and eventually
our clients.

Thanks to Tom, I have coded a simple form that selects an existing table
from a worksheet based on one user imput. It looks like this:

Private Sub cmd2_proj1_Click()

Dim StartCell As String
StartCell = txt1_proj1.Text

Range(StartCell).CurrentRegion.Select

End Sub

What I'd like to do next is "dump" this selection into an array. Since we
are constantly working with different and changing table sizes, I can't
necessarily say how big the array will be. I'm thinking there is a way to
extract the selection dimensions into cell reference form, but I haven't
found it yet.

So...is this a relatively simple procedure? Am I missing or not providing
some critical information?

From reading all the posts I'm realizing there is a wealth of commands
particular to VBA and Excel, and I'm savvy enough to guess at their
purpose - I just don't know how to use them. Any links or books
(specifically for Excel) you would recommend that list these commands and
functions and what they do would be greatly appreciated.

TIA!

-gk-

By the way, I did NOT find "VBA For Dummies" very helpful.