Search and copy macro review needed

I found the following macro and it works for exactly what I need. I have a sheet with a project name in one column, and a bunch of dates in all the other columns. A user would run the macro and type in the date they are searching for. The matching data of the entire row is then pasted into a new sheet. Below is the code I am using:

Please Login or Register  to view this content.

The issue I have is I only want the macro to search certain columns, not the entire sheet. I see columns are called out by lngLstDatCol = .Columns.Count + .Column - 1, but I am hoping someone can give me some guidance on how to search select columnns, and the entire column. For instance search columns C, F, M. Any help would be greatly appreciated.