vba courses london - Excel vba

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Excel vba

Gunaratnam has attended:
Excel Advanced course
Excel VBA course
Access Advanced course
Access Intermediate course

by - delegate Gunaratnam [4 posts] (2007 Apr 27 Fri, 11:21) Reply

i want to copy a result (name) on a different sheet one after another in asenting order.

RE: excel vba

by - trainer Garry gold contributer [188 posts] (2007 May 4 Fri, 14:28) Reply

Try this
Range("A1:A4").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = True
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

RE: excel vba

by - delegate Gunaratnam [4 posts] (2007 May 10 Thu, 09:30) Reply

thanky you
in the above code
how the system will find the next available empty cell to past the data.

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips