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
|