View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Cossitt Don Cossitt is offline
external usenet poster
 
Posts: 10
Default ShowDataForm of Worksheet class failed

Sub AddProduct()
Application.ScreenUpdating = False

Range("AA1:AB1").Select
Range(Selection, Selection.End(xlDown)).Select ' error with or
without this line
Application.CutCopyMode = False ' error
with or without this line
ActiveSheet.ShowDataForm '
produces the error

Application.ScreenUpdating = True

End Sub

I can produce the form manually selecting Data|Form. However, when trying
to add more items, get "cannot extend list or database".

Any ideas?

TIA
doco