Identify Entire Row of a Table

[shawnvw]

When the user selects any cell in Table1, I want to highlight the whole row of the table. (Please note that the table does not start on Row 1 of the spreadsheet.)

I need to either select the entire row, or set it as a range, based on what cell is selected.

How can i do this in VBA? Thanks.

[JBeaucaire]

You've asked several questions as if they were the same things, they are not. Please outline exactly the one thing you want to do....

1) Set a range variable in vba based on the current select cell

Please Login or Register  to view this content.

2) Select/Highlight the current row that is selected

Please Login or Register  to view this content.

3) Copy the entire row of the currently selected cell

Please Login or Register  to view this content.

etc...

[Ron Coderre]

Maybe something like this.....
• Select the sheet that contains the table
• Right-click on the tab name and select: View Code...to open the VBA editor for that sheet module
• Copy the below VBA code and past it into that module:

Please Login or Register  to view this content.

When you return to your worksheet....Whenever you click on any cell within the table body
...All additional formats on the table are cleared
...The entire table row is highlighted yellow.

Note: I used a table name of "Table1". Change that in the code to your table's name

EDITED TO INCLUDE THIS ALTERNATIVE:
If you meant you want to SELECT that table row...use this code instead:

Please Login or Register  to view this content.

[shawnvw]

You've asked several questions as if they were the same things, they are not. Please outline exactly the one thing you want to do....

1) Set a range variable in vba based on the current select cell

Please Login or Register  to view this content.

2) Select/Highlight the current row that is selected

Please Login or Register  to view this content.

3) Copy the entire row of the currently selected cell

Please Login or Register  to view this content.

etc...

I want to change the background color of a table row to yellow. (That's what I meant by "highlight"). The ".Interior" command has to follow a Range name or "Selection" or "Target".

The code I originally tried was something like this:

Please Login or Register  to view this content.

The problem is that "EntireRow" selects the entire row of the worksheet. I only want to highlight the current row of the table that takes up Columns G through Q. (And I may move the table again, so I don't want to refer specifically to "G" and "Q".)


EDIT: Ron, what I wanted was your second suggestion:

Please Login or Register  to view this content.

Thanks!

[Ron Coderre]

Glad you got something you can use!

Please be sure to mark this thread as SOLVED (from the Thread Tools menu)