Hello again, I'm sure I posted this about 10 minutes ago but its not come up
weird.

I have recorded the following code

Sub ShowDataEditForm()

Range("A5").Select
ActiveSheet.ShowDataForm

End Sub

But for some reason the form returns data from row 2, just a sheet heading.
Whereas the headings are in row 5 and the data below that.
Where am I going wrong? I've tried changing the first line to
Range("A5:I5").select but still the same result


--

_______________________
Naz,
London

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:
Hello again, I'm sure I posted this about 10 minutes ago but its not come up
weird.

I have recorded the following code

Sub ShowDataEditForm()

Range("A5").Select
ActiveSheet.ShowDataForm

End Sub

But for some reason the form returns data from row 2, just a sheet heading.
Whereas the headings are in row 5 and the data below that.
Where am I going wrong? I've tried changing the first line to
Range("A5:I5").select but still the same result




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