Hello,
I'm having trouble with something very simple and cannot figure out why!
I'm replicating the Data > Form command using:
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![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I'm having trouble with something very simple and cannot figure out why!
I'm replicating the Data > Form command using:
Code:
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