Excel DataForm not picking up correct list
 

Hi again,

I've written this code, headings are in row 5 and the data below.

Sub ShowEditForm()

Range("A5:O5").Select
ActiveSheet.ShowDataForm

End Sub

But when run it keeps on picking up data from row 2. A sheet heading and
nothing else.
What am I doing wrong.


--

_______________________
Naz,
London

Excel DataForm not picking up correct list
 

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


Naz wrote:
Hi again,

I've written this code, headings are in row 5 and the data below.

Sub ShowEditForm()

Range("A5:O5").Select
ActiveSheet.ShowDataForm

End Sub

But when run it keeps on picking up data from row 2. A sheet heading and
nothing else.
What am I doing wrong.




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