vba table header name

The solution for “vba table header name” can be found here. The following code will assist you in solving the problem.

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)

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts