Excel _knows_ where to look for the data (and screws up).

Here's an article that explains how the problem occurs in VBA (with solution)
http://support.microsoft.com/default...;en-us;q110462
XL: ShowDataForm Method Fails If Data Can't Be Found



Jim Cox wrote:

I am trying to active a form from a macro. I used the 'copy' function but it
fails. It tells me that the ShowDataFrom method failed. The spreadsheet will
be used my schools in our district to register students for the science
fair. I'm not the proficient in Excel.

Sub InputList()
'
' InputList Macro
' Macro recorded 10/5/2006 by 'Jim C'

'
Sheets("Names").Select
Range("A4:E4").Select
ActiveSheet.ShowDataForm
End Sub

Thanks Jim C

--

Dave Peterson