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
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