How do I select a row with vba?

[Lil2606]

Hi all,

I'm sitting in front of a deadline project and I seem to be forgetting the basics.. my own name will be the next one.. I'm getting compile errors and I can't figure out the correct syntax.

Sub try_this()


Sheet4.Activate


Dim headerrowin As Long


headerrowin = Sheet4.ListObjects("Table3").HeaderRowRange.Row


'Select the entire ("headerrowin-th" --> 85th) row I need to refer to it in the context of the sheet not the table.. so, something like Sheet4.ListObjects("Table3").HeaderRowRange.EntireRow.Select won't do.

Sheet4.Range(??????


End Sub

Could someone help please?

 

[Norie]

What is it you want to select exactly?

 

[Lil2606]

[COLOR=#333333]Sheet4.ListObjects("Table3").HeaderRowRange.EntireRow.Select[/COLOR]

that just with a different syntax which doesn't include listobjects

 

[Norie]

Not 100% sure what you want to select but this will select the entire row that the header row of 'Table3' on Sheet4 is on.

Dim headerrowin As Long
Dim rng As Range

    headerrowin = Sheet4.ListObjects("Table3").HeaderRowRange.Row

    Sheet4.Rows(headerrowin).Select

 

[Lil2606]

Yupp thats the one I was looking for! Thanks!