adamsm
02-05-2011, 02:36 PM
Hi,
The code behind the attched workbook is designed to filter the sheet when the search text is written above the column headers.
The code works fine when the column starts from column A. But the code does not work fine when the column starts from column C.
How could the code be adjusted so that it would filter the sheet when the search text is written on row 9 above the column headers on any column from column C to column K.
Any help on this would be kindly appreciated.
The code behind the attched workbook is designed to filter the sheet when the search text is written above the column headers.
The code works fine when the column starts from column A. But the code does not work fine when the column starts from column C.
How could the code be adjusted so that it would filter the sheet when the search text is written on row 9 above the column headers on any column from column C to column K.
Any help on this would be kindly appreciated.