VBA Programming

Closed
Mukesh.sagar
Posts
1
Registration date
Monday March 24, 2014
Status
Member
Last seen
March 24, 2014
- Mar 24, 2014 at 07:34 AM
Gowrisankar.T
Posts
9
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
April 8, 2014
- Mar 26, 2014 at 01:02 PM
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.

1 reply

Gowrisankar.T
Posts
9
Registration date
Wednesday March 26, 2014
Status
Member
Last seen
April 8, 2014

Mar 26, 2014 at 01:02 PM
Try this..
...
Sheets("Sheet1").select
cells.select
selection.copy
Sheets("Sheet2").select
range("a1").select
activesheet.paste
..........
0