Vba table header name

Dim tb As ListObject
'assumes Table is the first one on the ActiveSheet
Set tb = ActiveSheet.ListObjects(1)
MsgBox tb.DataBodyRange.Cells(2, tb.ListColumns("header4").Index)

Source: stackoverflow.com

Similar codes

0 vote260 views1 answer
If statement vdhl
VBA
0 vote228 views1 answer
Check range is in another range vba
VBA
0 vote250 views2 answers
Vb.net include quotes in string
VBA
0 vote218 views1 answer
Excel vba hide columns
VBA
18 votes319 views3 answers
Excel-vba make integer
VBA
0 vote224 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote242 views1 answer
Vbscript check if string is empty
VBA
1 vote233 views1 answer
Excel vba get ordinal number from cardinal number
VBA
8 votes243 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote245 views1 answer
Excel vba protect scenarios
VBA