Hi,
I have an excel sheet with which I want a macro button to bring up the Data
Form (simply instead of going to the menu dataform).

ActiveSheet.ShowDataForm
End Sub

Problem is that I have a row above the column headings which has merged
cells and when the macro runs it seems to not like it. Although if I simply
goto DataForm via the menu it works. I suspect I need to define range or to
exclude the row that has the merged cells rather than simply ActiveSheet. I
have tried but doing something wrong...

Please help!