Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Excel vba

vba courses london - Excel vba

ResolvedVersion Standard

Fri 27 Apr 2007, 11:21 Delegate Gunaratnam said...

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

Excel vba

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

Fri 4 May 2007, 14:28 Trainer Garry said...

RE: excel vba

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

Thu 10 May 2007, 09:30 Delegate Gunaratnam said...

RE: excel vba

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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

vba courses london - Excel vba

Excel vba

RE: excel vba

RE: excel vba

VBA articles

VBA tip:

Stop Display Alerts In Excel