Go to same row by table header

[SanjayGMusafir]

Hi Experts
Right now I'm using VBA that goes to an intended column in the same row. Can there be a way where, it can jump within same row to the intended column by table header name, as I keep adding or removing columns to the table and every time I do so, I have modify so many such vba(s)

Right now I'm using -

Sheets("Client").Select
    
Range("AB" & (ActiveCell.Row)).Select

 

[Fluff]

Is your table a structured table or just normal data?

 

[SanjayGMusafir]

Fluff It's a structured Table

Just for Eg - I want to go to same row of active cell but in column with Header "Palms"

Thanks a lot ��

 

[SanjayGMusafir]

FluffIt's a structured Table

Just for Eg - I want to go to same row of active cell but in column with Header "Palms" in table "Clients"

Thanks a lot

 

[Fluff]

How about

Sub Sanjay()
   Dim Rw As Long
   With Sheet12.ListObjects("Clients")
      Rw = ActiveCell.Row - .HeaderRowRange.Row
      .ListColumns("Palms").DataBodyRange.Cells(Rw, 1).Select
   End With
End Sub

 

[SanjayGMusafir]

Thanks Fluff

It worked like charm.

Thanks again

 

[Fluff]

You're welcome & thanks for the feedback