Search a string in first cell of each column and then get the column name

[Tanaji15]

Hi All,

I am totally new to the macros and VB scripting. Currently I am trying to Search a string in first cell of each column and the get the name of that column which will help me to plot the graph for that particular column.

I am able to write the code to search the entered string but not able to the corresponding column name. Can you please help me here to write the code.

Thanks a lot in advance.

Thanks,
Tanaji

[OllieB]

You can try

Please Login or Register  to view this content.

[OllieB]

You can try

Please Login or Register  to view this content.