Data in a table
Data in a table
(OP)
I need a visual basic code to pick up the data in a table. Please help!
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Data in a table
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Data in a table
=INDEX($C$17:$Q$24,MATCH(H9,$B$17:$B$24,0),MATCH($B$9,$C$16:$Q$16))
If you do want to get the table data into a VBA array then give the table range a range name (say pipe_data) and create a VBA variable of variant type (that could be pipe_data as well) then:
Dim Pipe_Data as variant
Pipe_Data = range("pipe_data").value2
Will get all the data from your table into the VBA array.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Data in a table
RE: Data in a table
RE: Data in a table
I try not to put too much into a formula because it becomes hard to understand.
RE: Data in a table