Counting columns until certain data is found

[Quickstepbr]

Hello,

I need to count the # of columns from lets say a1 until a specific value is foun in the same row.

How can I do this?

Thanks for the help.

[VBA Noob]

Take a look at the match function

http://www.contextures.com/xlFunctions03.html

VBA Noob