View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Naz Naz is offline
external usenet poster
 
Posts: 85
Default Excel DataForm not shwoing right data

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