Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How would I modify the following?
Sub MinReport()
RC= Sheets("15mintest").Select Range("A2:G2").Select Selection.Copy ActiveCell.SpecialCells(xlLastCell).Select Range().Select ActiveSheet.Paste Sheets("Master").Select End Sub What I want to do is make it so it does not interfer with what sheet I am working on now. Currently, it will select the sheet, paste data and then go back to Master Can I do this with out interfering with the screen I am on, and Not "selecting" the 15mintest sheet, just have it paste at the bottom of 15mintest? Thanks Bruce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify Before Send | Excel Discussion (Misc queries) | |||
Trying to modify a list | Excel Discussion (Misc queries) | |||
Modify a UDF please? | Excel Worksheet Functions | |||
Modify a UDF please? | Excel Worksheet Functions | |||
Modify width | Setting up and Configuration of Excel |