How would I modify the following?
Bruce,
Not too sure of how this is working - but amend this code to copy from
one sheet and paste to another without selecting anything... And it doesn't
matter what the active sheet is...
Sheets("Sheet1").Range("A2:G2").Copy _
Destination:= Sheets("Sheet2").Range("A1")
--
sb
"BruceJ" wrote in message
news:WTCnb.52055$Tr4.108464@attbi_s03...
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
|