Excel 2007 : advanced filtering issue

I am trying to run an advanced filter through VBA so that a pre-made re-order form can be filled in automatically. I am running into an issue because parts of the form have merged cells with text wrap. I can get the coding to work in any columns that do not have merged cells in them.

Does anyone know how to get around the merged cells?

Usually the best option is to not merge cells...merging often puts you in situations like the one that you are faced with right now. You can get a similar effect by using the "Center Across Selection" option in the horizontal alignment options in cell formatting, and then wrapping the text. That will allow you to get the same look of formatting, but it wont actually merge the cells.

Hope that helps.

The form I have to used was not designed by me. It is pretty extensive or else I would just re-make it myself without merging any cells but since I don't have 6 extra hours a day to try to do that I have to find another way. Any other ideas?