need code to find a word in a column make that numbered row the new variable.

[swade730]

Hi,

Just trying to alter the following code....


I would normally have the user enter where the word Heading is...

Dim Row As String
Row = InputBox("Enter First Row of Headers (e.g. 7)")


But I want excel to find the word Headers and return the rown number...

Any help is appreciated

[nigelbloomy]

Does this do what you need?

Please Login or Register  to view this content.

[swade730]

I wuv you thank you!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

I don't think it's a good idea to give a variable a name like row. Maybe HeaderRow or something else.

[nigelbloomy]

I like John's advice as well.
@Swade730 if that answers your question please mark the thread as solved and give rep points to all those who helped.