Selecting a table row in a table using VBA

[bearcub]

Hi,

If I have a table and I want to highlight the table row (ala conditional formatting a row in a table) -- how would I do that?

I original thought of using the current range property but that will select the entire table not active table row where I have my cursor.

My first thought is to do something like this:

Range(Activecell.end(xlRight), Activecell.end(xlLeft). select

However, I don't think this would really work in VBA and there is probably a more efficient and correct what of doing this.

What am I doing wrong?

Michael

 

[bearcub]

Thank you for the answers.

Yes, the column is doing to be dynamic because the column location will not always be the same. Sometimes the cell might be in Column C or Column D or Column A. I like the highlight only the row that has data in it, not the empty cells that are to the left or right of the data.

Michael

 

[MARK858]

I like the highlight only the row that has data in it, not the empty cells that are to the left or right of the data

What is wrong with the code Rick posted in post #7?

 

[bearcub]

Sorry, didn't mean to come off like that. It actually worked great and I thought it was cool the way he used Intersect method.

All code snippets worked and I was really in awe of the different ways to arrive at the same conclusion.

Thank you all for you help!

Michael

 

[MARK858]

I like the highlight only the row that has data in it, not the empty cells that are to the left or right of the data

All code snippets worked

The code I posted in post #9 doesn't work for the condition in bold. It always starts in column A.
To match the condition it would need to be...

Sub xxx()
    If Cells(ActiveCell.Row, 1) <> "" Then
        Range(Cells(ActiveCell.Row, 1), Cells(ActiveCell.Row, Columns.Count).End(xlToLeft)).Select
    Else
        Range(Cells(ActiveCell.Row, 1).End(xlToRight), Cells(ActiveCell.Row, Columns.Count).End(xlToLeft)).Select
    End If
End Sub

 

[bearcub]

Ah, I see that I didn't reread what I wrote. There was a typo in that sentence. I didn't mean to say "like the highlight" I meant to say "want to highlight". Apologize for the confusion.

I did try your original code and the newest one and they seem to work okay either way. Thank you for taking the time to provide the correction.

Michael