Select table header by column name

**Undo** · 06-01-2022, 10:05 AM

Hello

How can I select only one column header
Table name: Table1
Column name: Price

**MarvinP** · 06-01-2022, 10:43 AM

Hi Undo,

In VBA you need to use ListObjects in your code to work with a table and its Heading. See:
https://www.thespreadsheetguru.com/b...t-excel-tables
for more information. If the above doesn't give you an answer then keep asking and supply a sample workbook for a better answer.

**Sintek** · 06-02-2022, 02:55 AM

Please Login or Register  to view this content.

**Artik** · 06-02-2022, 09:38 AM

User needs are different. The important thing is to get to Rome.

Here is another of the ways

Please Login or Register  to view this content.

Artik

Select table header by column name

LinkBack

Thread Tools

Rate This Thread

Display

Select table header by column name

Re: Select table header by column name

Re: Select table header by column name

Re: Select table header by column name

Thread Information

Users Browsing this Thread

Similar Threads

Excel VBA to select header from Sheet1 at A1 to the end of the table, and paste it to ...

[SOLVED] Search nearest value above in table. return header row + header column

Sort Select Range: Either Find Column Header or Last Column:Last Row

[SOLVED] Find specific value in table and return header row and header column value

[SOLVED] Extract the column header given the row header and highest value in a subset of a table

How can I select one column from pivot table and use it in the page header ?

How to select column by header

Bookmarks

Bookmarks

Posting Permissions