When you use the ShowDataForm method, Excel looks for a range named
Database, or a table that starts in the range A1:B2. The following MSKB
article has some information:


ShowDataForm Method Fails If Data Can't Be Found
http://support.microsoft.com/default.aspx?id=110462

There are naming instructions he

http://www.contextures.com/xlNames01.html


Peter J Aldersley wrote:
I am unable to get a dataform to work within a macro without an error being
generated. Is this a problem in Excel or is it not possible to use dataforms
within macros?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html