Why FIND returns nothing with structured table?

Question

Hoping someone could shed something on my line of vba script below and point out the error:

Sub findKeyword()

Dim tbl as ListObject

set tbl = activesheet.ListOBjects("myTable") 'containing a header row

set r as range

set r = tbl.ListRows(1).Range.Find("name")

End sub

the Find keeps returning nothing when the header called name does exist in the header row of the structured table. On the other hand, set r = activesheet.rows(1).find("name") is able to find the search text.

Debug.Print tbl.ListRows(1).Range.Address will clarify it all. — VBasic2008
– VBasic2008, Commented Dec 7, 2023 at 19:12

Tim Williams · Accepted Answer · 2023-12-07 17:50:54Z

2

ListRows = all the rows of data in the ListObject.

It's not the range with the headers.

tbl.Listcolumns("name")

will give you a reference to the "name" column.

answered Dec 7, 2023 at 17:50

Tim Williams

169k8 gold badges104 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why FIND returns nothing with structured table?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related