Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Excel vba
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba courses london - Excel vba
Resolved · Low Priority · Version Standard
ReplyFri 27 Apr 2007, 11:21Delegate Gunaratnam said...
Excel vba
i want to copy a result (name) on a different sheet one after another in asenting order.For upcoming training course dates see: Pricing & availability
RE: excel vba
Try thisRange("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
ReplyThu 10 May 2007, 09:30Delegate Gunaratnam said...
RE: excel vba
thanky youin the above code
how the system will find the next available empty cell to past the data.
|
 |
|
» Forum post: Access |
I Have a table in Access That is linked to an excel file. Can the table in access be made a normal table ie not linked to the excel file?
