View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BruceJ[_2_] BruceJ[_2_] is offline
external usenet poster
 
Posts: 43
Default 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