Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
paste method of worksheet class failed | Excel Programming | |||
Copy Method of WorkSheet Class Failed! | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming | |||
Copy Method of Worksheet Class Failed | Excel Programming |