I have created an Excel spreadsheet from an Access table using the excel.Application object in VBA and all I want to do is make a single row have the drop down filters.
If you were in an Excel spreadsheet you would simply select the row and click on the "Filter" option under "Sort and filter".
If I wanted to make the row grey then i would simply do something like
oExcelWrSht.Range("A12:J12").Interior.ColorIndex = 15
So i am hoping it will be something similar. i.e. declare the range and use a property to make all the cells have a drop down filter.
Any thoughts anyone?