VBA Programming

Closed
Mukesh.sagar Posts 1 Registration date Monday 24 March 2014 Status Member Last seen 24 March 2014 - 24 Mar 2014 à 07:34
Gowrisankar.T Posts 8 Registration date Wednesday 26 March 2014 Status Member Last seen 8 April 2014 - 26 Mar 2014 à 13:02
I want to copy the excel sheet with in the same worksheet, using the VBA Programing i.e. on the click of the button. The new sheet is in the sorted format based on the first column.
Related:

1 response

Gowrisankar.T Posts 8 Registration date Wednesday 26 March 2014 Status Member Last seen 8 April 2014
26 Mar 2014 à 13:02
Try this..
...
Sheets("Sheet1").select
cells.select
selection.copy
Sheets("Sheet2").select
range("a1").select
activesheet.paste
..........