new user - Need help

[gapa]

Hi,

I am a new user to Excel VBA.

Basically I want to perform a loop that searched values in a Row.

Normally, if it is in a column, this is what I would do

========

aaa=2

Do until Range("A"& aaa)="Something"
aaa=aaa+1
loop

========


How would i change this to look thru the rows ?

Thanks

Paul

 

[Lewiy]

Perhaps you can be more specific as to what you want to do. The example you have posted will look through rows as you have asked until it finds a particular value and then stops without doing anything else

 

[DiscoPistol]

Private Sub CommandButton1_Click()
aaa = 2

Do Until Range("A1").Offset(0, aaa) = "X"
aaa = aaa + 1
Loop
End Sub

 

[gapa]

hi,

Acutally, I want it to look thru the range heading of a pivot table, almost similar to a hlookup function. I need to know the column number so that I can make refers to it.

Hope this is clearer. But i guess the "offset" will works just as well

thanks