DataForm Problem

[Andywiz]

Hello,

I'm having trouble with something very simple and cannot figure out why!

I'm replicating the Data > Form command using:

Range("b200").End(xlUp).Select
ActiveSheet.ShowDataForm

However, this fails to open the Data Form correctly, insisting that "Microsoft Excel cannot determine which row in your list or selection contains column labels", and thereby opening a DataForm that does not contain the correct fields for entry.

Normally, I understand this to mean that I don't have any column headers. However, I do, and in fact if I perform this manually by actually clicking Data > Form, it opens the data form correctly without problems.

Can anybody suggest why this might be happening and help me resolve it, please?

Many thanks in advance,
Andywiz

 

[Tom Urtis]

Oh - good morning, Tom! Um, not following, what's the alt-N gonna do for us?

Good morning to you too Greg. It's gonna do nothing in the US. When I stuck that code in my library it was during a time when I was editing hundreds of macros by Hans Herber while working on the CD, and this %n was used in European macros to help call the dataform. I imagine this has significance with European keyboards (especially German and French from what I can gather) but I have never been able to test that. It has no value in America for Excel but does not do much damage either in code execution, just one SendKeys command, so I kept it in the code in case a user happens to be in Europe with the same problem. If anyone in Europe reads this I'd be interested to know what Alt+N does for Excel, maybe equivalent of Ctrl+O for Open (??).

Looks like Andrew nailed this one, thanks.