Select Table(Column)

**taleb** · 09-28-2017, 01:58 PM

I have a problem that happened today to my excel. I have a table defined on one of the sheets. when I try to select a column in that table using the selection button it returns the RANGE not the table[column] name. I am selecting this using the button in Conditional Formatting and Data Validation for example.

I tried opening another file and it is happening there too.

**63falcondude** · 09-28-2017, 02:05 PM

When the table is expanded, the range in the Conditional Formatting rule is automatically adjusted to account for that expansion.

I assume Data Validation is the same.

Select Table(Column)

LinkBack

Thread Tools

Rate This Thread

Display

Select Table(Column)

Re: Select Table(Column)

Thread Information

Users Browsing this Thread

Similar Threads

Select cell from table based on values in row 1, and column A

Select column from table using variable table name -- VBA

Macro to select 1 column and a variable number of table rows.

Select a cell in a table when Row name & Column name is given

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

Macro to select a specific column of filtered data in a table

[SOLVED] How to select from a table of values based upon column and row headers

Bookmarks

Bookmarks

Posting Permissions