Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I convert a user defined selection into an array?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
user defined function | Excel Worksheet Functions | |||
User defined function | New Users to Excel | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming |