Improve company productivity with a Business Account.Sign Up

x
?
Solved

Read top row,cell value from a table, Excel 2010

Posted on 2013-01-10
4
Medium Priority
?
307 Views
Last Modified: 2013-02-13
Hi,
Can you pls suggest me in reading top (row,cell) value from a excel 2010 table
FYI, Table -> is from SQL datasource

example i have a table named (MyTable) .. which can be filtered
A        B            C
1      Name      Dept          Project
2      Henry      501            GGG
3      Lynn              201            GGG
7      Henry      401            KKK
8      Joe            101            RRR
9      Lynn              301            KKK

Rrequirement : always read value from the (first row , second column) from the table.

Note:- Table can be filtered.

Thanks
0
Comment
Question by:kishan66
  • 2
4 Comments
 
LVL 53

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 38763288
MyCell = Cells(1, 2).Value
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 500 total points
ID: 38763332
Do you mean the first visible row, or just the first row even if it's hidden?
If the former, perhaps:

msgbox Activesheet.Listobjects(1).ListColumns(2).DataBodyRange.Specialcells(xlcelltypevisible).cells(1)

Open in new window

0
 

Author Comment

by:kishan66
ID: 38763464
rorya,

its the first visible row.

i dont understand ur suggested answer.

can u give an example w.r.t. the below table -> Table Name # MyTable
A        B            C
1      Name      Dept          Project
2      Henry      501            GGG
3      Lynn              201            GGG
7      Henry      401            KKK
8      Joe            101            RRR
9      Lynn              301            KKK

Now filter table column B by "Henry". MyTable is srinked to two rows (in this instance).
Now i want 1st row, 2nd column value.

Expected Output :  Henry

How should i get that.
0
 

Author Closing Comment

by:kishan66
ID: 38886560
I want to close the ticket/issue as i did not get the answer
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question