| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Active Sheet
I am trying to put together a very simple piece of code that copies data from
one sheet and pastes into another However every time a new worksheet is created the code cannot find the last active sheet Example: Sheets.Add After:=Sheets(Sheets.Count) Sheets("APS Structure").Select Cells.Select Range("AD7").Activate Selection.Copy Sheets("Sheet2").Select Range("A1").Select ActiveSheet.Paste Range("A1").Select How do I change the "sheet2" to the last active sheet I was viewing? Your help is much appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to sort an active sheet using the col of the active cell | Excel Programming | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
| How do i copy a active sheet to a new sheet with code and everything | Excel Programming | |||
| Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Threaded Mode
