Input data via user form.
Posted by tee on July 16, 2001 11:40 PM
Hi Everyone - can I call upon someone for help again.
I have code to enter data from a userform to the spreadsheet but it is slow. It copies the info to a range of cells and then copies it to the spreadsheet.
Like so.
Sheets("Formula").Select
Range("A1:T1").Select
Selection.Copy
Sheets("DB").Select
Range("A1").Select
Selection.End(xlDown).Select
Selection.Offset(1, 0).Range("A1:T1").Select
Selection.Insert Shift:=xlDown
Application.CutCopyMode = False
Many thanks in advance
Tee.