Need Help in generalizing the search criteria in Macro code

[Haidar123]

This code searches the "Time" Column in first ten rows and copies it to another sheet...
if I have encountered with such a column whose title is "Time in seconds" then it will not search this column...What i want is the modification of this code such that it can detect column which contains any part of "Time" word in it

Regards

[TMS]

Try changing xlWhole to xlPart


Regards, TMS

[Haidar123]

Thanks bro

[TMS]

You're welcome. Thanks for the rep.